BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation (247879)

SYMPTOMS

You can create database maintenance plans on a Microsoft Data Engine (MSDE) installation by using the Database Maintenance Plan Wizard in the SQL Server 7.0 Enterprise Manager that is installed on another remote workstation. However, you cannot edit or delete the Database Maintenance plans on MSDE after they are created because there is not a "Database Maintenance Plans" node in the Enterprise Manager tree when you view an MSDE installation.

MORE INFORMATION

The SQLMaint.exe file performs maintenance operations on one or more databases. You can use SQLMaint.exe to run database consistency checker (DBCC) checks, back up a database and its transaction log, update statistics, and rebuild indexes.

You can create SQLMAINT jobs on an MSDE installation by running the Database Maintenance Wizard and using Enterprise Manager on a remote workstation.

REFERENCES

For additional information about SQLMaint.exe for MSDE, click the article number below to view the article in the Microsoft Knowledge Base:

246815 FIX: Sqlmaint.exe is Not Included in MSDE Installation

SQL Server Books Online; topic: "sqlmaint Utility"

For additional information about installing MSDE, see the Readme.txt file in the MSDE Web download package or in the MSDE CD.

For more information about installing and distributing MSDE by using an Installer application, see the following Microsoft Web site:

http://msdn.microsoft.com/vstudio/msde/instdwnld.asp

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

234626 SAMPLE: Setup1.exe Fully Automating MSDE Setup with the Package and Deployment Wizard (PDW)

Resources for developers building applications with MSDE, including white papers, general additional FAQS, and sample code can be found at the following Microsoft Web site:

http://msdn.microsoft.com/vstudio/msde