Transaction Log Backup Job for DB Maintenance Plan Failed

[DBA2RELOADED]

I recently upgraded SQL 7.0 to SQL 2000, and after the upgrade, I'm getting this failed run on Transaction Log Backup Job for DB Maintenance Plan. The errors are logged in Windows Application Event Log, as well as, in the Maintainance Plan Log File.

The error on the Windows Application Event Log is:

SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'xxxxxx Maint Plan'' (0x056FA9180A08D511A409001083FC5CCD) - Status: Failed - Invoked on: 2003-05-20 09:00:00 - Message: The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last step to run was step 1 (Step 1).

The excerpt of the error on the Maintainance Plan Log is:

[3] Database xxxxxxxxx: Check Data and Index Linkage...

** Execution Time: 0 hrs, 0 mins, 25 secs **

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

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

End of maintenance plan 'Ceridian Maint Plan' on 5/20/03 9:00:30 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)


Any idea? Thanks!

DBA2RELOADED

 

[SQLBill]

That's correct, nothing is wrong. You CAN'T backup the Transaction Log for MASTER. MASTER's Recover Model (in Enterprise Manager drill down to the databases, right click on Master, select Properties, go to the Options tab) is set for SIMPLE and can't be changed. You can try, but it will revert to SIMPLE. MSDB starts as SIMPLE, but I believe it can be changed to FULL. SIMPLE does not allow Transaction Log backups.

-SQLBill

 

[DBA2RELOADED]

SQLBill - Thanks for the info.