Home Forums Article Discussions Article Discussions by Author Discuss content posted by Suja James Full backup Scenario RE: Full backup Scenario

  • March 31, 2010 at 12:42 am

    #1142862

    Tom.Thomson (3/19/2010)

    If I undertand it rightly, the correct wording is more like "from the start of the oldest transaction that was uncommitted at the start of the backup, or from the first log entry after the start of the backup if there is no such transaction".

    The start LSN of the backup is the minimum of:

  • The LSN of the last checkpoint (note the backup operation starts by issuing a checkpoint)
  • The LSN of the start of the oldest active transaction
  • The LSN of the last replicated transaction

    • See http://sqlkpi.com/BLOGS/PAUL/post/Debunking-a-couple-of-myths-around-full-database-backups.aspx

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi