Export (0) Print
Expand All

Transaction Log Architecture

SQL Server 2008 R2

The topics in this section provide the basic architectural information required to understand how the transaction log is used to guarantee the data integrity of the database and how it is used for data recovery.

Understanding the information in this section can help improve your effectiveness in managing transaction logs.

Transaction Log Logical Architecture

Describes the logical architecture of the transaction log.

Transaction Log Physical Architecture

Describes the physical components of the transaction log file, including virtual log files.

Checkpoints and the Active Portion of the Log

Describes the checkpoint operation and the effect of checkpoints on the transaction log.

Write-Ahead Transaction Log

Describes the role of the write-ahead transaction log in recording data modifications to disk.

Community Additions

© 2016 Microsoft