Open Transactions Stuck in the Log of a Database in Simple Recovery Mode
You have transactions stuck in the Transaction Log; the log won’t truncate; the log won’t shrink; the database is in Simple Recovery Mode; What do you do? (SQL Server 2008; DBCC LOGINFO; DBCC OPENTRAN;)