Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Monitor Replication Agents from Management Studio (SQL Server Management Studio)

Microsoft SQL Server Management Studio provides the following dialog boxes for monitoring replication agents:

  • View Snapshot Agent Status (for all publications)

  • View Log Reader Agent Status (for all transactional publications)

  • View Synchronization Status (for all subscriptions; this dialog box allows access to the Distribution Agent and the Merge Agent)

Replication Monitor provides additional information about each agent and provides monitoring for the Queue Reader Agent, if it is used. For more information, see How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor), How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor), and How to: View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor).

To monitor the Snapshot Agent and Log Reader Agent

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

  2. Expand the Replication folder, and then expand the Local Publications folder.

  3. Right-click a publication, and then click View Log Reader Agent Status or View Snapshot Agent Status.

  4. In the View Log Reader Agent Status or View Snapshot Agent Status dialog box:

    • View agent status.

    • Start or stop the agent if necessary.

    • Click Monitor to launch Replication Monitor.

  5. Click Close.

To monitor the Distribution Agent and Merge Agent (from the Publisher)

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

  2. Expand the Replication folder, and then expand the Local Publications folder.

  3. Expand the publication for the subscription you want to monitor.

  4. Right-click the subscription, and then click View Synchronization Status.

  5. In the View Synchronization Status dialog box:

    • View agent status.

    • Start or stop the agent if necessary.

    • For push subscriptions, click Monitor to launch Replication Monitor.

    • For pull subscriptions, click View Job History to launch the Log File Viewer, which displays output from the agent log.

  6. Click Close.

To monitor the Distribution Agent and Merge Agent (from the Subscriber)

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

  2. Expand the Replication folder, and then expand the Local Subscriptions folder.

  3. Right-click the subscription you want to monitor, and then click View Synchronization Status.

  4. In the View Synchronization Status dialog box:

    • View agent status.

    • Start or stop the agent if necessary.

    • Click View Job History to launch the Log File Viewer, which displays output from the agent log.

  5. Click Close.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.