Our database transaction log has grown from 500MB to 9Gb very quickly and we are now running out of disk space.
We have tried Backup Log with Truncate_only
also DBCC shrinkfile (log_file_name,1000)
We read about a method of solving this by detaching the database however this database is a publisher in merge replication and we get an error message back.
We have set the recovery model from Full to Simple with no joy.
We have tried stopping the SQL Server and renaming the Log file with no success.
We have tried restarting the Server with no success.
We are using SQL 2005 SP2 on a dell quad core 8Gb Ram server using Windows 2003 OS.
DBCC OPENTRAN returns message
Transaction information for database databasename.
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (1298820:6778:1)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
...indicating uncommitted replication transactions I believe.