SQL Server Interview Question #264

What is the SQL Server transaction log?

SQL Server Internals & Administration Senior Advanced

Detailed Explanation

The transaction log records database modifications and other information required for transactional consistency, rollback, crash recovery, backup/recovery, and several high-availability or replication technologies.

SQL Server uses write-ahead logging: relevant log records must be hardened before corresponding modified data pages are written to disk.

The log is not simply a historical audit trail. It is a core part of the database engine's recovery architecture.