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 ?
asked Mar 20, 2017 at 01:37 PM in Default
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.
answered Mar 20, 2017 at 02:04 PM