Microsoft KB Archive/247879

= BUG: Cannot Edit or Delete Database Maintenance Plan on MSDE Installation =

Article ID: 247879

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft Data Engine 1.0

-



This article was previously published under Q247879



BUG #: 57061 (SQLBUG_70)



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.



WORKAROUND
You can manually edit or delete SQLMAINT jobs in the Management/ SQL Server Agent/ Jobs node of the Enterprise Manager tree.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.



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.