Question : When you take full backup, do it capture data till the time backup start time or till the time backup end.
Answer : Full backup capture database till the backup completion time. Let check it :-
1) I have initiated the TEST database backup with buffercount =1 so that backup took some time & I can insert some data in meanwhile.
2) You can see that we have data in BackupTest table in between of backup start & end time.
3) Now, I restored Database TEST as TEST2 & found that data is available in BackupTest table that was inserted during backup.
Note : Differential backup also works same like full backup in this case.
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
