Replication Monitor
You have defined a publication and are ready to push data to a subscriber. What if something goes wrong? SQL Server provides a tool to aid DBAs with troubleshooting replication problems. The Replication Monitor helps pinpoint problems with replication.
When a server functions as a distributor and the user is in the sysadmin role, replication monitoring is enabled. The Replication Monitor can be used for viewing publishers, publications, and all subscriptions. The following replication objects can be monitored by the Replication Monitor:
Subscriptions to the publication
Snapshot Agent
LogReader Agent
Distribution Agent
Merge Agent
Miscellaneous Agents (cleanup)
Replication Alerts
If you create a publication and synchronization fails, ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
