July 24, 2003 at 3:00 pm
Normally under Management Folder in EM I see an Icon named Database Maintenance Plans. I was just informed of three new SQL Server Db installs and when I went to create a Maintenance Plan there's no Icon. I used the MP Wizard and can create one but I can't modify it or see it.
What's up with that?
July 24, 2003 at 10:49 pm
Thats strange. I was going to suggest that you don't have privileges, but if that were the case then you wouldn't be able to use the MP wizard. What fixed server roles are you a member of?
Cheers,
- Mark
July 25, 2003 at 8:40 am
All security checks good, local admin on server and sa on Db. Might be on to something here, checked job results and had following message:
Failed executing API: CreateProcess. [SQLSTATE 42000] (Error 22029). The step failed.
Looking for API on other MSSQL servers.
July 25, 2003 at 1:14 pm
Re-installed MSSQL - db maint plans now shows. still getting Failed executing API: CreateProcess message when trying to run db backup job. Anyone know anything about the CreateProcess API?
July 29, 2003 at 1:48 pm
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.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply