Got something strange (to me ) going on with my SQL Server 2005 database. The log file has very gradually grown huge.
shows everything in the log is active (Status 2)
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?