x

If there is DB of size 300 GB and takes 3 hours for full backup, will the transactions going at time of backup also get included in backup ?

If there is DB of size 300 GB and takes 3 hours for full backup, will the transactions going at time of backup also get included in backup ?

more ▼

asked Mar 20 at 01:37 PM in Default

avatar image

arshad9997
11 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Sorta. The backup is a page by page copy of the allocated data within the data file in addition to enough of the transaction log file to ensure database consistency. If the transaction is completed prior to the backup ending, the data itself won't reflect the changes however the transaction log would have the record of the data modification. During recovery, the transaction should be rolled forward with the information from the transaction log.

If the transaction is not completed by the time the backup process ends, the transaction log would have enough detail to roll that transaction back. This is what ensures data consitency.

This article might help: https://technet.microsoft.com/en-us/library/2009.07.sqlbackup.aspx

Hope that helps.

more ▼

answered Mar 20 at 02:04 PM

avatar image

JohnM
13.6k 3 7 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x244
x8

asked: Mar 20 at 01:37 PM

Seen: 25 times

Last Updated: Mar 20 at 02:04 PM

Copyright 2016 Redgate Software. Privacy Policy