Wednesday, April 09, 2008

How to troubleshoot problems that occur when you use a Database Maintenance plan in SQL Server

If any task in a Database Maintenance plan fails or encounters an error
message, the maintenance plan job itself may show as failed. The Job
History Details shows the following Error message:



sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

However, this does not necessarily indicate that the Maintenance Plan
as a whole has failed.

The Maintenance Plan job shows a status of
failed in order to raise a flag to the user that a task in the
maintenance plan requires attention.

Resolution:

Any time a maintenance plan job fails, you must check the plan history
to see what the failure is and then take the appropriate action to
resolve the problem.

How to troubleshoot problems that occur when you use a Database Maintenance plan in SQL Server

No comments: