Answer
The transaction log is an append-only structure that records all modifications. SQL Server uses Write-Ahead Logging (WAL):
- Log records are written to disk first
- Data pages update later
This ensures atomicity and durability. Log truncation depends on checkpoints and active transactions.