Lynn Pettis (3/15/2013)
If I interpret it correctly, looks like all of the VLFs in the log file have open transactions. Until all the transactions are committed or rolled back, SQL Server can't mark them as reuseable.
Not necessarily open transactions. Something that's preventing log truncation. Could be:
Open transaction
No log backup
Mirroring
Replication
CDC
Active backup
Checkpoint
or a couple other less common ones
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