Post reply

sql agent error from database backup plan

  • May 30, 2005 at 7:59 am

    #109417

    SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0x1A3D79A120911549B9F1243B73556452) - Status: Failed - Invoked on: 2005-05-26 05:00:01 - Message: The job failed.  The Job was invoked by Schedule 6 (Schedule 1).  The last step to run was step 1 (Step 1).

    2 other pieces of info: db work has ben done during backup plan time and database has been accessesed during that time also.

    Is there any other reason that just one database in my plan wont backup.

    Please clarify this error for me.

    Thanks for your help in advance

    webdaddy

  • May 30, 2005 at 10:44 pm

    #561803

    Check that the area the backup file is going to allows the create/write operation. (And has sufficient space)

    Check that the database recovery mode is "Full"

    What db work was done ?

    DB

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • May 31, 2005 at 5:14 am

    #561837

    I really dont know but the db was accessed directly

     

    webdaddy

  • May 31, 2005 at 1:02 pm

    #561996

    If you right-click on the Maintenance plan, then click maintenance plan history and find the job that failed and double-click it, you should get a much better error message.

    Or you might try the sql server error log.

  • May 31, 2005 at 1:06 pm

    #561998

    Sorry, neglected to include this in last post.

    Check your database options to see if the recovery method hasn't been set to simple. This will cause a tran log backup to fail in sql 2000 whereas it didn't in sql7.

  • May 31, 2005 at 1:10 pm

    #561999

    Thanks Randy, It is simple. I will change it tonight.

     

    webdaddy

  • May 31, 2005 at 3:20 pm

    #562037

    Ahem,

    "Check that the area the backup file is going to allows the create/write operation. (And has sufficient space)

    ***** Check that the database recovery mode is "Full"

    What db work was done ?"

    Setting the database recvery mode to "Simple" might have been done to save space in the backup destination or on the backup sytem (tape etc). You better find out why it was done or there might be other problems.

    Cheers,

    DB


    The systems fine with no users loggged in. Can we keep it that way ?br>

Viewing 7 posts - 1 through 6 (of 6 total)

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