GilaMonster (3/15/2013)
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
Okay, okay, my internal voice was saying that, I just didn't say it that way in my post. I am officially chastised on this event. I will endeavour to be more specific and concise in the future. I was right, though, that you would come along and provide guidance.