July 29, 2010 at 10:18 pm
Hi friends,
Suppose i have database of size 450gb
Backup of this database takes 3hrs to complete.
and users finish there working by 7:00PM daily
if i start backup at 5:00 PM it will finish at 8:00PM.
how much data is recoverable?
is it upto 5:00PM or 8:00PM?
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
July 29, 2010 at 10:39 pm
Short answer: the backup is transactionally consistent to the point when it finished (8pm).
Longer answer: consider this thread: http://www.sqlservercentral.com/Forums/Topic958470-391-1.aspx#bm958540
July 30, 2010 at 12:12 am
thanx a lot jim, u saved my life..............
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply