Restore Sequence
-
If i have a FULL backup on Sunday evening @ 8:00 PM and succeeding a Differential backup @ 7:00 AM everyday(MON,TUE,WED,THU,FRI) with this LOG Backup for every 4 hours each day and my database(EX: TESTDB) had crashed at 6:00 PM on Friday what is the Restore sequence
Ans : First a Full backup with no recovery,
step 2 : All the Differential backups since last full backup with no recovery,
step 3: All the log backups since last full backup with recovery, STOPAT <time or LSN number>
Can anyone say this sequence is this correct or not?
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Save a tree... Please don't waste paper unless you really need to!
When life puts into problem don't say 'God Why Me' say:w00t: 'Try Me'
-
You do not need all the DIFFs after the full, just the last one.
-
Duplicate post.
Replies here please: http://www.sqlservercentral.com/Forums/FindPost1692414.aspx
-- Gianluca Sartori
-
info.sqldbamail (6/8/2015)
If i have a FULL backup on Sunday evening @ 8:00 PM and succeeding a Differential backup @ 7:00 AM everyday(MON,TUE,WED,THU,FRI) with this LOG Backup for every 4 hours each day and my database(EX: TESTDB) had crashed at 6:00 PM on Friday what is the Restore sequenceAns : First a Full backup with no recovery,
step 2 : All the Differential backups since last full backup with no recovery,
step 3: All the log backups since last full backup with recovery, STOPAT <time or LSN number>
Can anyone say this sequence is this correct or not?
Your differential is all changes since the last backup. Each differential doesn't care about the one before it, so it has all the same changes as the last differential, plus anything new. That is why diff backup file sizs get bigger and bigger until the next full backup is taken.
So all you would need would be:
The full from Sunday evening
The Diff from Friday morning 7am
Then all the logs from 7am to point in time restore to 6pm. If you can, take a tail backup of the database to get the data changes just before the failure, otherwise you will only be able to get to the last succesfull log backup. This could be at the most, 4 hours before 6pm depending on the log backup times.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply