Post reply

Log backup fails in maintenance plan

  • January 13, 2004 at 7:14 am

    #107356

    I keep getting alerts that the log backup for one of the databases from one of our maintenance plans is failing. Yet it looks like the backup is getting completed successfully. The SQL Server logs show that the backup was created successfully, and a restore from the logs works OK.

    Does anyone have any idea why SQL Server Agent would be reporting that the backup is failing?

    Thanks

    Tim Harding

    Tim

  • January 13, 2004 at 9:03 am

    #489772

    In SQL7/2000 you can a look in the msdb table 'sysdbmaintplan_history' to see if there is a reason. Try that table.

    (SQL 2000 Code) 

    select substring(database_name,1,17) as 'database', activity ,start_time  as 'start', message from sysdbmaintplan_history  where succeeded <> 1 order by database_name, start_time desc

    Steven

  • January 16, 2004 at 10:54 am

    #490486

    if your database recovery mode is set to "simple", then from BOL 'You get an error if you try to back up the log while in SIMPLE recovery mode'

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

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