Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 CreateProcess API ?

Author  Topic 

gfahrlander
Starting Member

23 Posts

Posted - 2003-07-28 : 09:25:03
Failed executing API: CreateProcess message when trying to run db backup job. Anyone know anything about the CreateProcess API?

No trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced!

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-07-28 : 09:36:17
How are you running the backup job? Scheduled TSQL or what?
Go to Top of Page

gfahrlander
Starting Member

23 Posts

Posted - 2003-07-29 : 15:48:08
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.

No trees were killed in posting this message. However, a large number of electrons were seriously inconvenienced!
Go to Top of Page
   

- Advertisement -