Home » SQL Server » Does Full Backup contain data inserted during backup ?

Does Full Backup contain data inserted during backup ?

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 :-




Other Linked Profiles :-





Leave a Reply

%d bloggers like this: