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

Adding SQL Server 2005 as a Peer-to-Peer node

If, for some reasons, we need to add SQL Server 2005 as a P2P Node, here are the steps to follow:

  1. As SQL Server 2005 doesn't support conflict detection for P2P Replication, we have to disable the conflict detection, as shown in the following screenshot, before we go about adding a SQL Server 2005 as a new Peer-to-Peer node.
    Adding SQL Server 2005 as a Peer-to-Peer node
  2. Expand the replication node. Select Configure Peer-to-Peer Replication.
  3. Select the publication and database.
  4. In the Configure Topology screen, right-click and select Add a New Peer Node.

    Note

    Notice that this is the SQL Server 2005 instance and that the conflict detection has been disabled. ...

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