I have a database whose tlog has grown to 4.5 GB. The db is in full recovery mode and I have tried several transaction log backups coupled with DBCC shrinkfile. And it will not shrink. Does anyone have any ideas?
There are several transactions which have a status =2, but there are no active transactions in the database. I wonder why they still show up with status=2.