Microsoft KB Archive/247879

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 12:50, 21 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


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.

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:

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