June 30, 2011 at 5:48 am
Scenario:
Full backup is taken on Sunday.
Differential is taken each weekday at 7:00 AM
Logs are backed up every 15 mins.
Lets imagine on wednesday at 6 pm i have a need to restore.
1. Restore full backup with norecovery
2. Restore Differential with norecovery.
3. Restore all logs since differential, with recovery on the last one.
But this is where i get confused. How do i know what log Exactly to start with?
Do i use the first log backup taken after the diff finished?
Do i use the first log backup taken after diff started (would be log at 7:15)?
Do i use log taken at 7:00am, same time the diff kicked off?
June 30, 2011 at 6:30 am
Start with the earliest of the options, SQL will tell you if the log backup is not needed.
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
June 30, 2011 at 6:32 am
Awesome and accurate as always! Thanks Gail!
July 1, 2011 at 12:07 am
winston Smith (6/30/2011)
Scenario:But this is where i get confused. How do i know what log Exactly to start with?
Do i use the first log backup taken after the diff finished?
Do i use the first log backup taken after diff started (would be log at 7:15)?
Do i use log taken at 7:00am, same time the diff kicked off?
To add gail's reply
Check the backupset table in MSDB. It'll give you the right path.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply