Transaction Replication - Stop Log reader and re-initialize.


  • Hello,

    Is there a way to stop the log reader agent and re-initialize by taking a new snapshot.

    Thanks in advance.

    Wednesday, May 2, 2018 1:21 PM

All replies

  • You can do a sp_stop_job and then sp_reinitsubscription.

    However, there is no need to stop the log reader agent to re-initialize or to generate a new snapshot.

    Wednesday, May 2, 2018 4:13 PM
  • Thanks Hilary,

    When we go with major updates to the data, log reader also takes so long time to prepare the replication commands,

    In this situation, I would like to stop the log reader and re-initialize with a new snapshot.

    But we get error when we re-initialize the new snapshot when log reader is stopped.

    Thursday, May 3, 2018 11:33 AM
  • What error are you getting? And what version/edition of SQL Server do you have?
    Thursday, May 3, 2018 1:29 PM