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

  • 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