Home Forums SQL Server 2005 Backups Backup strategy RE: Backup strategy
Steve Jones - SSC Editor
SSC Guru
Points: 734449
More actions
April 2, 2010 at 9:24 am
#1144852
Lynn is correct. If you cannot backup the tail of the log (http://msdn.microsoft.com/en-us/library/ms179314.aspx), you can't recover that data from 8:00 on.
I think you'd restore
- Sun full
- Mon diff
- Mon log backups after diff until 8pm