Post reply

Transaction log backups ran during a full backup.

  • June 7, 2012 at 7:43 am

    #275217

    We have the disaster recovery exercise during the next week. I have Transactional log backups running during the time frame of full backup. Can anyone please let me know the right order to restore ?

    :crying:

  • June 7, 2012 at 7:49 am

    #1498175

    If the log backup finished before the full, it's probably not necessary so you can start with the first log backup that finished after the full backup finished. If SQL does need the earlier log backup it will tell you.

    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 7, 2012 at 7:52 am

    #1498177

    thanks

    🙂

  • June 7, 2012 at 12:17 pm

    #1498349

    But if you're unsure, you can check the header information on the full backup and the log backup and compare the begin and end log sequence numbers (LSN). These will tell you if the log backup data is covered by the full backup or not.

    "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

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

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