Merge Replication - Start/Stop Synchronization
-
Mittwoch, 13. Februar 2013 22:28
I created a merge replication months ago running in continious mode. I recently came upon a need to stop the synchronization and then start it again. I typically do this manually via the "Replication Monitor", right clicking on the subscription and selecting "Stop Synchrozation", then later right clicking on the subscription and selecting "Start Synchrozation". I need the ability to do this in script. I have found many start/stop agent scripts but not this one. Manual steps below that I need script to accomplish.
ALL - Thanks in advance...
Alle Antworten
-
Mittwoch, 13. Februar 2013 22:51Moderator
If it is a Merge push subscription use:
- sp_stopmergepushsubscription_agent
- sp_startmergepushsubscription_agent
If it is a Merge pull subscription use:
- sp_stopmergepullsubscription_agent
- sp_startmergepullsubscription_agent
- Als Antwort markiert ddride Mittwoch, 13. Februar 2013 23:01
.png)
.png)
