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

- URL: https://dynamicaccounting.net/weekly-dynamic-why-wont-the-sql-transaction-log-clear/
- Date: 2011-05-09
- Topics: SQL & Data, Tips & Hidden Features
- Type: link to an external article
- Source: http://msdynamicsgp.blogspot.com/2011/04/find-databases-where-sql-server-log.html

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

- [To Find Databases Where the Log is Too Big](http://msdynamicsgp.blogspot.com/2011/04/find-databases-where-sql-server-log.html)
- To find out [Why the Transaction Log is Full](http://msdynamicsgp.blogspot.com/2011/02/why-is-my-transaction-log-full.html)
- [To Monitor the Transaction Log for Unusual Growth](http://msdynamicsgp.blogspot.com/2010/01/weekly-dynamic-sql-script-to-monitor.html)

This week, courtesy of the illustrious [Paul Randal](https://www.sqlskills.com/), 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: