Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Maintenance plan failing

Posted on 2006-04-05
Medium Priority
Last Modified: 2008-01-09
Our maintenance plan is failing.  The error is:

Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed.

How can this be resolved?

Our script is as follows:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 87B2B5E0-5886-4737-948C-2660F58BF8A7 -Rpt "l:\mssql\MSSQL\LOG\Update Statistics - All DB - Weekly0.txt" -DelTxtRpt 4WEEKS -WriteHistory  -RebldIdx 10 '
Question by:jpipitone
LVL 70

Accepted Solution

Scott Pletcher earned 2000 total points
ID: 16383711
Look at the "Maintenance Plan History" instead of the job output.  That should give you a better indication of the problem.
LVL 20

Expert Comment

ID: 16384249
Also look at the logs...

Author Comment

ID: 16384469
Here's the error I found when looking at Maintenance Plan History - one of our databases Conferences is read only....this would explain why our plan is failing....I'll have to check with our development team to see why they're locking this db down.


[Microsoft SQL-DMO (ODBC SQLState: 25000)] Error 3906: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not run BEGIN TRANSACTION in database 'Conferences' because the database is read-only.

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question