Monitoring Replication

Replication Monitor is a component of SQL Server Enterprise Manager designed for viewing the status of replication agents and troubleshooting potential problems at a Distributor. Replication Monitor is activated as a component only when the server is enabled as a Distributor and the current user is a member of the sysadmin fixed server role. All replication agents must be scheduled through SQL Server Agent.

You can use Replication Monitor in SQL Server Enterprise Manager to:

• View a list of Publishers, publications, and subscriptions to the publications that are supported by the Distributor.
• View scheduled replication agents, and to monitor real-time “heartbeat” status and history for each agent.
• Set up and monitor alerts related to replication events.

  If the event occurs, Microsoft® SQL Server™ will respond automatically, either by executing a task that you have defined or by sending an e-mail or a pager message to the specified operator.

After replication has been set up, you can also use the Microsoft Windows NT® Event Viewer to view SQL Server messages. For information about Event Viewer, see Windows NT Help.