Microsoft KB Archive/285288

= Transaction log backups of master database are not allowed =

Article ID: 285288

Article Last Modified on 12/21/2005

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q285288





SYMPTOMS
If you create a Database Maintenance Plan for all the system databases or if you select the master database and you select the Back up the transaction log as part of the maintenance plan option, the Backup transaction log step for the master database fails with this error message:

SQLMAINT.EXE Process Exit Code: 1 (Failed)

Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]

Backup can not be performed on database 'master'. This sub task is ignored.



CAUSE
Only full database backups of the master database are allowed.



MORE INFORMATION
The master database should be kept as the default in the Simple Recovery model. You must create a separate maintenance plan for the master database and not backup the transaction log in the maintenance plan. Create additional maintenance plans as needed for other databases for which you want to backup the transaction log.

If you want, you can set the msdb database to the Full Recovery model and perform transaction log backups. If the recovery model for msdb is set to &quot;simple&quot; the backup transaction log step in the maintenance plan fails with the error message shown in the &quot;Summary&quot; section.