Re: Transaction Log grows out of control from Replication



Gary,
the strange thing is that this looks like a transactional replication output
gained from DBCC OPENTRAN but sp_helppublication indicates not. If you are
100% sure there is no transactional replication going on from this database,
then run sp_repldone (http://doc.ddart.net/mssql/sql70/sp_ra-rz_15.htm) and
then truncate the log and shrink it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .




.


Loading