Database Main. Plan

Hello,

I have set-up a new SQL 2000 server. Created a Database Mainteance Plan. I get the following error when backup is run:

"SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'System DB's'' (0xAD16C5E02F3C0348B51471AB7BB3DD96) - Status: Failed - Invoked on: 2002-10-21 00:00:01 - Message: The job failed. The Job was invoked by Schedule 11 (Schedule 1). The last step to run was step 1 (Step 1). "

Can anyone assist?

ThanksThe only thing that I can think of is to create and run a backup seperate from the maintenance plan to isolate the error better, becuase u are right that error doesnt mean anything to me eaither.
Originally posted by akvag
Hello,

I have set-up a new SQL 2000 server. Created a Database Mainteance Plan. I get the following error when backup is run:

"SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'System DB's'' (0xAD16C5E02F3C0348B51471AB7BB3DD96) - Status: Failed - Invoked on: 2002-10-21 00:00:01 - Message: The job failed. The Job was invoked by Schedule 11 (Schedule 1). The last step to run was step 1 (Step 1). "

Can anyone assist?

Thanks|||RE: Hello, I have set-up a new SQL 2000 server. Created a Database Mainteance Plan. I get the following error when backup is run:

"SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'System DB's'' (0xAD16C5E02F3C0348B51471AB7BB3DD96) - Status: Failed - Invoked on: 2002-10-21 00:00:01 - Message: The job failed. The Job was invoked by Schedule 11 (Schedule 1). The last step to run was step 1 (Step 1). " Can anyone assist? Thanks

Q1 Can anyone assist?

A1 Note that in regard to 'System Databases', e.g. Master:
You can only perform a full backup of the master database. A 'Transaction Log Backup Job' therefore should not be included as part of a maintenance plan for such 'System Databases'.