SQL Databases, Backup, and Free Space

Microsoft SQL databases have two components: Transaction Logs (.LDF) and Databases (.MDF).    Transaction Logs are designed to keep track of each transaction with the database.   If properly configured, they can provide some fault tolerance to failures.

Read more