Understanding Transacation Log and Recovery Model

Every SQL Server database has a transaction log that records all transactions and the database modifications that are made by each transaction. The transaction log is a critical component of the database and, if there is a system failure, the transaction log might be required to bring your database back to a consistent state. This guide provides information about the architecture of the transaction log and its various different uses in SQL Server.

Read more Understanding Transacation Log and Recovery Model