Search notes:

SQL Server: transaction log

The transaction log guarantees the database's date integrity and allows for data recovery.

log record

A log record consists of

LSN
Transaction ID
The data modification record

log record sequence number (LSN)

The LSN (log sequence number) identifies each log record.

Write ahead log (WAL)

First write the log record details then flush the page.

Path to log file directory

The path to the directory with the instance log files can be selected with serverproperty('InstanceDefaultLogPath')

See also