How to pause SQL Server data subscription service

Text: How to pause SQL Server data subscription service

Starting and stopping the Snapshot Agent or Log Reader Agent from Management Studio

1. Connect to the publisher in Management Studio, and then expand the server node and the replication folder.

2. Expand the local Publications folder, and then right-click the publication.

3. Click View Snapshot Agent status or View Log Reader Agent status.

4. Click start or stop.

starting and stopping the Queue Reader Agent from management Studio

1. Connect to the Distributor in Management Studio, and then expand the server node.

2. Expand The SQL Server Agents folder, and then expand the Jobs folder.

3. Right-click the job for the agent, and then click Start Job or stop job. the Queue Reader Agent's job name is in the format [< distributor >].< integer >.

To start and stop the Snapshot Agent, Log Reader Agent, or Queue Reader Agent from Replication Monitor

1. In the left pane, expand the Publishing server group, expand one of the publishers, and then click one of the publications.

2. Click the Agents tab.

3. Right-click the agent, and then click Start Agent or stop Agent.

How to pause SQL Server data subscription service