SQL Server 2005 Log file wont shrink
Posted on 2010-11-24
We have a log file that was apparently always around 1gb in size, after an update to the system that uses the db the log file shot up to 17gb and now shrink.
DBCC OPENTRAN (RE7) - (where RE7 is the name of DB)
and i get the following results.
Transaction information for database 'RE7'.
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (83521:309:1)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Does anyone have troubleshooting tips i can use to find out what is locking at this size? im guessings its a transaction that never completed?