Re: Transaction Log grows out of control from Replication



Gary - are you sure that you don't have any transactional publications
there? What get's returned if you run sp_helppublication?
Another posibility is that you have a transaction open - can you run dbcc
opentran to see if this is the case?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .


.