sqlbuddy123 (3/4/2014)
Use this query ..
SELECT [log_reuse_wait_desc]
FROM [master].[sys].[databases]
--WHERE [name] = N'DB_Name';
That's just going to give a list of all the log reuse for all the DB on the server. It needs either the database name adding as a column or the predicate commenting out, otherwise it'll be hard to tell which reuse reason is for which DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability