SQL Server: log files

Log files store the data that is needed to recover transactions.

The typical filename extension of log files is .ldf.

Because log files are written whenever a transaction commits, they often have high I/O rates and for good performance, it's crucial that data can be written fast.