Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unanswered: 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?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: Database Main. Plan

    The 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
    Last edited by JDionne; 10-25-02 at 10:26.

  3. #3
    Join Date
    Oct 2002
    Posts
    369

    Post Re: Database Main. Plan

    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'.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •