Top 10 articles on the SQL Server transaction log

February 13, 2014 by Ivan Stankovic

Understanding Logging and Recovery in SQL Server

In “Understanding Logging and Recovery in SQL Server”, Paul S. Randal has given a complete overview of the transaction log. In four sections he explains: what is logging, what is recovery, how the transaction log works, and which recovery models are available. This article can be used as a starting point in understanding fundamentals of the transaction log and the logging process Read more »

10 most important SQL Server transaction log myths

February 12, 2014 by Ivan Stankovic

Myth: SQL transaction log truncation will make it smaller Read more »

A beginner’s guide to SQL Server transaction logs

February 11, 2014 by Ivan Stankovic

What is a transaction log?

A transaction log is a file – integral part of every SQL Server database. It contains log records produced during the logging process in a SQL Server database. The transaction log is the most important component of a SQL Server database when it comes to the disaster recovery – however, it must be uncorrupted. After each database modification – transaction occurrence, a log record is written to the transaction log. All the changes are written sequentially Read more »