3 out of 4 rated this helpful - Rate this topic

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.

In This Section

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.

Concepts

Working with Transaction Log Backups

Other Resources

Managing the Transaction Log

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD