June 6, 2007 at 4:49 am
Hi all ,
Is there any way to restore a differential backup when the database is running means its online.
Means i restored the full backup with recovery, and after 3 days , if i get a request to restore differential backup also.
Do, i have to again restore full bak with norecovery and then again restore differential bak with recovery.
Thanks.
Najeed.
June 6, 2007 at 7:01 am
Hi Dude,
No it is not needed,if u restored ur full backup today with recovery,and after some 3 days if u hav ur diff backup ,u can easily restore it normally as u would restore a full backup.
1stFull backup with recovery + N no of diff backup with recovery + tran1 log with norec +tran2 with norec +....+tran(n-1) log with norec+tran (n) log with recovery.
So ur tran log only needs to be applied in with norec except the last tran log!
Cheers
Deepak
[font="Verdana"]- Deepak[/font]
June 7, 2007 at 8:03 am
You can't restore a Diff. backup to an online database. You will have to restore the Full backup (WITH NORECOVERY), then restore the differential backup (WITH RECOVERY).
You only restore a single Differential backup, as subsequent Differential backups include all the changes since the last Full backup (and hence all the changes in the previous Differential backups).
For example:
Backup sequence:
Full
Log_1
Log_2
Diff_a
Log_3
Diff_b
Log_4
Diff_c
Log_5
To restore to Log_4:
Restore Sequence:
Full (With Norecovery)
Diff_b (With Norecovery)
Log_4 (With Recovery)
and then Diff_c and Log_5 are no longer applicable.
Sense Make?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply