Friday, February 24, 2012

Does a Full Backup include data changes made during the backup?

If my backup starts at 8PM and take 1 hour to complete, will the changes made to the database during that hour be captured in the full backup?

Stated another way, will my backup be a snapshot of:
a) 8PM when the backup started
b) 8PM with some of the changes made between the hour
c) 9PM when the backup finished?

Anybody know the exact way SQL Server handles that logic?

Thanks,

MarcFrom BOL (full backups [SQL Server]):
"A full backup (formerly known as a database backup) backs up the entire database, including part of the transaction log (so that the full backup can be recovered). Full backups represent the database at the time the backup completed. The transaction log included in the full backup allows it to be used to recover the database to the point in time at which the backup was completed. Creating a full backup is a single operation, usually scheduled to occur at regular intervals. "|||I remember reading in SAMS SQL 2000 DBA Guide, that the backup processes uses logic to make certain that the backup represents the state of the database when the backup is completed.

Regards,

hmscott

No comments:

Post a Comment