Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Transaction Log Architecture

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.