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? thanks
No 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.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/