“Why can’t I truncate my log file?!?”

I found a VERY useful query from Brent Ozar’s daily emails that go out on how you can check for the reason SQL Server is unable to truncate the log file (i.e. an open transaction, log backup etc)

Here are some of the reasons you will see:

“NOTHING”
“CHECKPOINT”
“LOG_BACKUP”
“ACTIVE_TRANSACTION”
“ACTIVE_BACKUP_OR_RESTORE”

Views – 458