Understanding 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.

In This Section

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.

See Also


Working with Transaction Log Backups

Other Resources

Managing the Transaction Log

Help and Information

Getting SQL Server 2005 Assistance