Garry Dawkins


Hello everyone and happy new year.

This is related to a maintenance plan that pushes data from one to another continuesly and eventully backs up the database.

This is the code "

EXECUTE master.dbo.xp_sqlmaint N'-PlanID CA2CE438-C14B-442C-AB75-D2838EAA8076 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "\\dca-05\sqldumps\weekly" -DelBkUps 3WEEKS -BkExt "BAK"'

Problem is I continue to get errors:

(9 row(s) affected)

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.





Re: Server: Msg 22029, Level 16, State 1, Line 0

Kuntal Loya - MSFT


Hi Garry,

The error you are getting is probably because you have selected the master database and Backup transactional logs in your maintanance plan. Only full backups of master database are allowed.

Please refer to http://support.microsoft.com/default.aspx/kb/285288 for more details.

Thanks,

Kuntal