Home Forums SQL Server 2005 Backups Transaction Log Backup Job Failure - does it break chain? RE: Transaction Log Backup Job Failure - does it break chain?

  • It kind of depends on the type of log backup failure, but yes, some of them will break the recovery chain. You'll pretty much know the next time you go to run the log backup. If it fails, you're in a broken chain situation.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning