Skip to content

start-and-stop-a-replication-agent-sql-server-management-studio.md

Latest commit

 

History

History
74 lines (50 loc) · 3.89 KB

start-and-stop-a-replication-agent-sql-server-management-studio.md

File metadata and controls

74 lines (50 loc) · 3.89 KB
title Start and Stop a Replication Agent (SQL Server Management Studio) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.component replication
ms.reviewer
ms.suite sql
ms.technology
replication
ms.tgt_pltfrm
ms.topic conceptual
helpviewer_keywords
agents [SQL Server replication], stopping
agents [SQL Server replication], starting
ms.assetid 97977c4a-8c7c-4a22-9480-69aa812bd1e5
caps.latest.revision 42
author MashaMSFT
ms.author mathoma
manager craigg

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

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] Start and stop agents from the Jobs folder and the Replication folder in [!INCLUDEmsCoName] [!INCLUDEssManStudioFull] 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 Synchronize a Push Subscription and Synchronize a Pull Subscription. For more information about maintenance jobs, see Run Replication Maintenance Jobs (SQL Server Management Studio).

For information about starting Replication Monitor, see Start the Replication Monitor.

To start and stop a Snapshot Agent or Log Reader Agent from Management Studio

  1. Connect to the Publisher in [!INCLUDEssManStudio], 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.

To start and stop a Queue Reader Agent from Management Studio

  1. Connect to the Distributor in [!INCLUDEssManStudio], 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>.

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

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

  2. Click the Agents tab.

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

See Also

Monitoring Replication
Replication Agent Executables Concepts
Replication Agents Overview