Home Forums SQL Server 2005 SS2K5 Replication Transaction Log Growing due to Pending Transaction (Replication) RE: Transaction Log Growing due to Pending Transaction (Replication)
Neeraj Dwivedi
SSCertifiable
Points: 6768
More actions
April 10, 2013 at 7:26 am
#1605215
You have to use 3 commands in sequence
1) exec sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0, @reset = 1
2) Truncate the Transaction log
3)sp_replflush