Unanswered: Transaction log backup fails on Master database
Hi. I'm trying to backup the transaction logs as part of a maintenance plan. I'm backing up two production databases and the master database. Whenever the job runs, it always fails, and it only backs up the transaction log for the production databases. This is the error I get in Windows event viewer:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'Master ApptPro TFit Full Backup'' (0x5E9E32B6A995CB469FF1F918521B1ADE) - Status: Failed - Invoked on: 2010-01-07 15:29:29 - Message: The job failed. The Job was invoked by User server\sql_server. The last step to run was step 1 (Step 1).
I'm trying to find any additional information about why the job is failing; but, I may be looking in the wrong places. I'm using SQL Server 2000 on Windows 2003. What could be causing this to fail? Thanks!
Executed as user: server\sql_server. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
This is also reported in the job history log:
Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'server' as 'server\sql_server' (trusted)
Starting maintenance plan 'DB Maintenance Plan2' on 01/08/2010 8:54:26 AM
Backup can not be performed on database 'master'. This sub task is ignored.