I'm in a situation where my backup failed and went unnoticed long enough for the log to consume the disk. I've added additional log space on another drive, not desirable but either is a crashed db. The issue seems to be that I have
rouge transactions in the sys.dm_tran_active_transactions and can't get rid of them.
There a 6 rows that are named worktable and have a time stamp of 1-24-11 which is before I setup replication and I believe these are preventing the log from releasing it's space. Can these rows be deleted if I can find the underlying sql table that's
behind the sys.dm_tran_active_transactions view? Well providing connecting to ADMIN:<dbname> puts me in a mode to do so.
SQL Server 2008 R2
Windows 2008 R2
Thanks for any help
View Complete Post