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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: