Issue with Maintenance Plan - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Issue with Maintenance Plan

Author

Topic

bharath63
Starting Member

14 Posts

Posted - 2009-02-11 : 15:38:08

Hi,
Maintenace paln for backing up datbase the Job for full database backup runs fine but the transcation log backup job fails with following error: Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

I tried a lot to find the information over the web regarding this error.

BHARATH

bharath63
Starting Member

14 Posts

Posted - 2009-02-11 : 15:57:53

Guys I worked around the problem.
Before I had removed the msdb from the Plan list because it was in simple recovery mode but it was no success.
But later I checked the logs and found the plan was not taking log backup of master even though it was in full recovery mode, so i removed the master database from the list as well and wonder it worked fine.

Now one question raises why the job had problem with master databases??

BHARATH

bharath63
Starting Member

14 Posts

Posted - 2009-02-12 : 14:15:00

I did find that Transaction log backups of master database are not allowed even if it is in full recovery mode..
Please refer http://support.microsoft.com/kb/285288/EN-US/

BHARATH

jmassi
Starting Member

2 Posts

Posted - 2009-03-04 : 09:00:28

I am having this same problem, although the msdb is not checked as part of the maintenance plan. I have read the MS KB article mentioned above but i cannot figure out why the trans log backups keep failing. Any insight would be most appreciated!