BackUp Maintenance Plan Failure

  • I know this is a known bug in SQL Server, but how do you get around this error:

    Event Type: Warning

    Event Source: SQLSERVERAGENT

    Event Category: Job Engine

    Event ID: 208

    Date: 8/25/2003

    Time: 2:00:00 AM

    User: N/A

    Computer: SRV913

    Description:

    SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan2'' (0x91845FF9107D0744AA1B6C04595CFA25) - Status: Failed - Invoked on: 2003-08-25 02:00:00 - Message: The job failed. The Job was invoked by Schedule 44 (Schedule 1). The last step to run was step 1 (Step 1).

    How do I determine which of my maintenance plans this is? All of my plans now have meaningful names and there is not one named - DB Maintenance Plan2. How do I determine which plan used to have that name? Or do I have delete all plans and start over again because I can not identify which job this error message is referring to.

  • So I guess there is nothing to be done and I have to start deleting backup jobs until I figure out which one this is.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply