Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    46

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

    Marc

  2. #2
    Join Date
    Nov 2005
    Posts
    122
    From 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. "

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    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
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •