Home Forums SQL Server 2005 SS2K5 Replication Transaction Log Growing due to Pending Transaction (Replication) RE: Transaction Log Growing due to Pending Transaction (Replication)

  • I have not found a solution as yet...

    I am Just maintaining the Logs by using sp_repldone and then shrinkfile..

    Any solutions...?

    I see the 2 subscribers are continually running and these are the ones that open up the transaction(begin tran)

    One more thing: This command "exec sp_executesql N'update MSreplication_subscriptions set transaction_timestamp " is running every second on the subscription database..