Home Forums Article Discussions Article Discussions by Author Discuss content posted by Tony Davis Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery RE: Stairway to Transaction Log Management in SQL Server, Level 3: Transaction Logs, Backup and Recovery

  • September 7, 2011 at 9:07 pm

    #1378344

    Correct - the only way to know whether a transaction is wholely contained within a data backup is if the LSN of the commit log record is within the range of LSNs backed up by the backup.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005