We are running SQL 2005, in an active/passive cluster. Our transaction logs are getting out of hand. The DBs are backed up twice daily, Full recovery model. Running DBCC SHRINKFILE returns Cannot shrink log file 2 (DB_Log) because all logical log files are in use. I'm not a DBA in any sense, but I have to keep the transaction logs in check until we fill the opening. A temporary maintenance plan I created to perform a transaction log backup and shrink completes successfully, but to no effect on the size of the log and no errors in the plan history. DBCC OPENTRAN returns: Code: Transaction information for database 'DB'. Replicated Transaction Information: Oldest distributed LSN : (0:0:0) Oldest non-distributed LSN : (5145:825:1) DBCC execution completed. If DBCC printed error messages, contact your system administrator.