09 May 2011

Weekly Dynamic: Why Won’t the SQL Transaction Log Clear?

In the past we’ve looked at the SQL transaction log
This week, courtesy of the illustrious Paul Randal, we have a SQL Script to help figure out why the log can’t clear. The script is

select log_reuse_wait_desc from sys.databases

and you get back results like this: