Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Maintenance plan fails
Message
From
22/02/2010 06:21:43
 
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01447290
Message ID:
01450182
Views:
35
Hello
Sorry for a late reply.
I couldn't find an entry in the server log that would point a finger at the error.
Knowing that the Plan used to work fine and noone touched it i simply rebooted the server. Now all is well.
Thanks you and all the best.

Kamil

>Did you check SQL Server log?
>
>>Hello
>>I created a maintainance plan which basically backs up a number of databases (master not included) but the plan fails. When i start the particular job responcible for the backup it also fails with the following message "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
>>SQLSTATE 42000 gives a pretty vague info.
>>Error 22029 i couldn't find in my BOL
>>Could you advise me on how to resolve such situations.
>>Regards
>>Kamil
A moment of silence is our cosmic reset button.
Previous
Reply
Map
View

Click here to load this message in the networking platform