Export (0) Print
Expand All

How to: Start and Stop a Replication Agent (SQL Server Management Studio)

Start and stop agents from the Jobs folder and the Replication folder in Microsoft SQL Server Management Studio and from Replication Monitor. Start and stop the following agents and jobs:

  • The Snapshot Agent, which is used by all publications.
  • The Log Reader Agent, which is used by all transactional publications.
  • The Queue Reader Agent, which is used by transactional publications enabled for queued updating subscriptions.
  • The Distribution Agent, which synchronizes subscriptions to transactional and snapshot publications.
  • The Merge Agent, which synchronizes subscriptions to merge publications.
  • Replication maintenance jobs.

For more information about starting the Merge Agent and the Distribution Agent, see How to: Synchronize a Push Subscription (SQL Server Management Studio) and How to: Synchronize a Pull Subscription (SQL Server Management Studio). For more information about maintenance jobs, see How to: Run Replication Maintenance Jobs (SQL Server Management Studio).

For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor).

  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 a publication.

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

  4. Click Start or Stop.

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

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

  3. Right-click the job for the agent, and then click Start Job or Stop Job. The name of the job for the Queue Reader Agent is in the form [<Distributor>].<integer>.

  1. Expand a Publisher group in the left pane, expand a Publisher, and then click a publication.

  2. Click the Warnings and Agents tab (the tab is Agents for Microsoft SQL Server 2000).

  3. Right-click an agent, and then click Start Agent or Stop Agent.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft