Troubleshooting Merge and Snapshot Replication
The best way to troubleshoot snapshot and merge replication is to use the Replication Monitor. The Replication Monitor visually alerts you when replication fails and provides detailed success and error messages.
NOTE
You can set up the agent to alert you via email, pager, or network message when something goes wrong. To add such capabilities to a publication agent, use the Agent Job Properties dialog box. You can bring up an Agent Job Properties dialog box by selecting the agent, right-clicking, and selecting Agent Properties. Figure 29.15 shows the Agent Job Properties dialog box with the Notifications tab selected. Use the Notifications tab to have the agent alert you via email or pager.
Figure ...
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.
