Got something strange (to me ) going on with my SQL Server 2005 database. The log file has very gradually grown huge.
Running
dbcc loginfo('dbname')
shows everything in the log is active (Status 2)
Running
dbcc opentran
shows 'no active open transactions'
so.... Not really sure what all the stuf in the transaction log is. The only glimmer of hope I've found is this post at sql server central but turning replication on and off seems a bit of a peculiar fix (sort of a variant of turn it off and on again I guess).
Any ideas what's up or what else to try/investigate?
thanks, Robin