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)
|
1 |
SELECT name, log_reuse_wait_desc FROM sys.databases; |
Here are some of the reasons you will see:
“NOTHING”
“CHECKPOINT”
“LOG_BACKUP”
“ACTIVE_TRANSACTION”
“ACTIVE_BACKUP_OR_RESTORE”
Views – 1786