Restoring a DB w/ T-Logs spanning Full DB Backups

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  May 14, 2008 at 12:41 pm

  #182436

  Let's say I take a Full backup 7 days a week at midnight, and am also running Transaction log backups 24/7.

  Now, on Monday, I need to restore back to Sunday at 6:00 pm, but my Friday & Saturday full backups got overwritten. Can I restore to Sunday 6 pm by using the Thursday midnight backup, and all the t-logs since then, even though there were full backups taken in between ? The Fri & Sat full backups don't break the t-log chain, do they ??

• Gordon-265412

  SSCrazy

  Points: 2898

  More actions

  May 14, 2008 at 12:46 pm

  #815487

  Yes, you're fine.

  A full backup does not mess up the LSN chaining.

  Your friendly High-Tech Janitor... 🙂

• KenpoDBA

  SSCrazy Eights

  Points: 9811

  More actions

  May 16, 2008 at 1:22 pm

  #816701

  I concur. Full backups don't touch the LSNs.

  Watch my free SQL Server Tutorials at:
  http://MidnightDBA.com
  Blog Author of:
  DBA Rant – http://www.MidnightDBA.com/DBARant

  Minion Maintenance is FREE: