SQL Server Performance Forum – Threads Archive

Maintance Plan

I am gettig following error when I ran Maintance plan? Executed as user: serverAdministrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

There is a lot of reason for that message.
For example if you maintenance plan include index rebuil and databas is in use, same error.
So, check if database is in use or other job is running.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Make sure your job is outputting to text file and check that. It’ll give more info. Tom Pullen
DBA, Oxfam GB

KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;288577 – to troubleshoot Maint.plans. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

erg,
we had a long discussion about MPlans at ::: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5058 I guess there are many pitfalls related to MP’s, so, we are studying the way to get around, you’ll have some news soon …

Wabbash link will help you to assess if you’re using any third party tools to perform backup operations. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>