muthukkumaran Kaliyamoorthy (6/20/2011)
kesmond (6/20/2011)
i gone thru the link that u have provided. but just have doubt over the transaction logs restore, as what i have painted on the scenario, we have to restore all the transaction logs from monday until thursday at the point of time? thanksNo need because the differential backup contains all the data (modified extents)
So you have differential backup upto on thursday. Just you can restore a log backup one by one after the differential backup has done.
That is restore a log backup every 5 min on thursday onwards upto your DB crash point.
Why do you think to restore a same data again and again ? That is diff cantains all the modified data.
I think you are not understanding the differential backup behavior.
Pls ask me if you have any doubt.
Really appreciate your prompt reply. I am rather new to sql so in terms of backup, would need your advice.
So i would do a restore from the full backup for Monday (with the restore option of Overwrite the existing data (WITH REPLACE) and also RESTORE WITH NORECOVERY), after that i do a differential restore on Thursday (with the restore option of Overwrite the existing data (WITH REPLACE and also RESTORE WITH NORECOVERY), lastly i will do a restore of the transaction log from thursday onwards every 5 mins (with the restore option of Overwrite the existing data (WITH REPLACE) and also RESTORE WITH RECOVERY), am i right? thanks.
So the transaction log restore would start from the time the differential backup was done. For example, the differential backup was done on thursday 130pm, so the transaction log restore would start from thursday 130pm onwards (every 5 mins), is my understanding correct? thanks