Post reply

Backup chain

  • June 19, 2014 at 11:54 am

    #309313

    Hi all,

    Would rebooting server break transaction log backup chain?

  • June 19, 2014 at 12:07 pm

    #1723387

    Short answer:

    Nope.

    😀

    Long answer:

    The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full. If you had a full backup from 4 years ago and every TLog backup since then, you could recover your DB up to the most recent TLog backup.

    Jason

  • June 19, 2014 at 12:10 pm

    #1723388

    Thank You.:-)

  • June 19, 2014 at 12:49 pm

    #1723403

    You're quite welcome!:-D

  • June 19, 2014 at 1:48 pm

    #1723421

    jasona.work (6/19/2014)

    The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full.

    Or delete a log backup. Or delete the transaction log itself.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 19, 2014 at 3:19 pm

    #1723428

    GilaMonster (6/19/2014)

    jasona.work (6/19/2014)

    The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full.

    Or delete a log backup. Or delete the transaction log itself.

    Wouldn't deleting the transaction log itself just terminate the Tlog backup chain, because if you had a full backup and all of the existing tlog backups, you still have a complete backup up to the time of the last tlog (minus uncommitted transactions)?

    Because when I've taken the full, differential and tlogs, and applied them to a new server (thus recreating the database there), the chain was intact, but there was no previous transaction log (new database and all).

  • June 20, 2014 at 1:04 am

    #1723472

    patrickmcginnis59 10839 (6/19/2014)

    GilaMonster (6/19/2014)

    jasona.work (6/19/2014)

    The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full.

    Or delete a log backup. Or delete the transaction log itself.

    Wouldn't deleting the transaction log itself just terminate the Tlog backup chain

    Well, since 'terminate' is what 'break' means, yes. As in, log chain broken, no further log backups possible until a new full/diff is taken, log backups can't be restored past the point of the break.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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