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.

    Mittwoch, 2. Mai 2018 13:21

Alle Antworten

  • 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.

    Mittwoch, 2. Mai 2018 16:13
  • 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.

    Donnerstag, 3. Mai 2018 11:33
  • What error are you getting? And what version/edition of SQL Server do you have?
    Donnerstag, 3. Mai 2018 13:29