Microsoft KB Archive/247879
Article ID: 247879
Article Last Modified on 10/17/2003
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft Data Engine 1.0
This article was previously published under Q247879
BUG #: 57061 (SQLBUG_70)
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.
You can manually edit or delete SQLMAINT jobs in the Management/ SQL Server Agent/ Jobs node of the Enterprise Manager tree.
Microsoft has confirmed this to be a problem in SQL Server 7.0.
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.
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:
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:
Keywords: kbbug kbpending KB247879