O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuration

In this section, we will learn how to configure alerts for Peer-to-Peer Replication. We will also learn how to remove a Peer Node and will add a new SQL Server 2005 instance as a new node. Because SQL Server 2005 doesn't support conflict detection, we have to disable conflict detection in the publication properties before adding SQL Server 2005 as a node.

Configuring alerts

So far we have learned how to install P2P Replication; let's now learn how to configure the alerts for the errors or conflicts, that is, conflict detection.

  1. Right-click on the Replication folder and select Launch Replication Monitor, or call sqlmonitor.exe to launch the replication monitor.
  2. In the warning tab, click on the Configure Alerts button; this will bring ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required