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

Article translations Article translations
Article ID: 246815 - View products that this article applies to.
This article was previously published under Q246815
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 56672 (SQLBUG_70)
Expand all | Collapse all

On This Page

Symptoms

You can create database maintenance plans on a Microsoft Data Engine (MSDE) installation using the Database Maintenance Plan Wizard from within the SQL 7.0 Enterprise Manager installed on another remote workstation. However, if you try to start one of the jobs generated by the Database Maintenance Plan Wizard, the following error occurs:
The job failed. The job was invoked by user DOMAIN\user. The last step to run was step 1 (Step 1).
If you review the job history and select the option Show step details, you will see the following text in the details for step 1:
Failed executing API: CreateProcess. [SQLSTATE 42000] (Error 22029). The step failed.
This message occurs for all jobs generated by the Database Maintenance Plan Wizard. However, manually generated jobs (for example, backup jobs) work correctly.

Cause

When you install the Microsoft Data Engine (MSDE) from the MSDE redistribution package, it does not install the Sqlmaint.exe tool.

Workaround

To work around this behavior:
  • Customers can obtain the Sqlmaint.exe file from the SQL Server Developer Edition that ships with MSDE for Visual Studio CD (\x86\binn\Sqlmaint.exe or \alpha\binn\Sqlmaint.exe) and package that tool in their setup programs.
  • Copy the Sqlmaint.exe file to the MSSQL7\BINN directory on the MSDE installation.

Status

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

More information

Sqlmaint.exe performs maintenance operations on one or more databases. You can use Sqlmaint to run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes.

REFERENCES

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)
For additional information on using the Sqlmaint tool, see SQL Server Books Online; topic: "sqlmaint Utility".

For additional information on 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 using an Installer application, see the following MSDN Web site:
hhttp://download.microsoft.com/download/vstudio60ent/Update/6/WIN98MeXP/EN-US/msdeinst.exe

Properties

Article ID: 246815 - Last Review: February 27, 2014 - Revision: 4.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix KB246815

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com