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

Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

In the past we’ve looked at the SQL transaction log

To Find Databases Where the Log is Too Big
To find out Why the Transaction Log is Full
To Monitor the Transaction Log for Unusual Growth

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:

Original article: http://msdynamicsgp.blogspot.com/2011/04/find-databases-where-sql-server-log.html