kesmond (6/20/2011)
thanks for the prompt reply. But lets say example, i do a full backup on monday and a differential backup daily and transaction log daily for every 5 mins.If i need to restore database on friday at 12pm. I have to restore the full backup on monday, follow by all the differential backups from monday to thursday and then from restore all the transaction logs from monday until friday 12pm? Is that correct?
It would takes hell lots of time trying to recover, am i right? thanks
Pls read the link which i have given. It ll clear your doubt.
Example from the article
For more clarity. See an example:
Assume we are scheduled every Sunday full backup @12 am and daily differential backup 10 PM.
Note: The data changes daily 500 MB.
Question:
How much data got back up on Thursday?
The student answers 500 MB.
As I already told, differential database backup "backs up all the data that has changed since the last full database backup".
So, the answer is,
Monday 500MB + Tuesday 500 MB + Wednesday 500MB + Thursday 500MB= 2000MB
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/