SqlBak Blog

SQL Server log file is too big – resolved!

sql-server-logoIf your SQL Server transaction log (LDF) file is too big – you are doing something wrong. As technet puts it:

Typically, truncation occurs automatically under the simple recovery model when database is backed up and under the full recovery model when the transaction log is backed up. However, truncation can be delayed by a number of factors. For more information, see Factors That Can Delay Log Truncation.

Read more