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

http://www.facebook.com/mssqlfun

http://mssqlfun.com/feed

https://twitter.com/Rgarg86

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

http://beyondrelational.com/members/RohitGarg/default.aspx

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: