Expand All
The document is archived and information here might be outdated

Understanding Transaction Log Architecture

Updated: 5 December 2005

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.

Topic Description

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.

© 2016 Microsoft