SQL Server Performance

Peer-Peer Replication

Discussion in 'SQL Server 2005 Replication' started by ndinakar, Aug 16, 2006.

  1. ndinakar Member

    Has anyone set up Peer-Peer replication so far?
    I was able to set it up but when I update a record at one node, the changes are not being replciated to the other node. The 2000 version was so simple. The new 2005 GUI seems confusing.

    I look at the Replication Monitor and under subscriptions, the status says "Not running". I tried to "Start Synchronizing" but the agents kept running for more than an hour an dI had to stop the sync.

    Any one has any ideas on how to move forward?

    Thanks,

    dinakar

    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************
  2. dineshasanka Moderator

    Yes I have done peer-to-peer replication successfully.

    I just followed the microsoft articles on this

    ----------------------------------------

  3. dineshasanka Moderator

  4. ndinakar Member

    Actually I was able to set it up using the BOL. I had issues with setting up the user account so the nodes can talk to each other and got that resolved with our Network Admin. I need to test a few scenarios like schema changes, IDENTITY column management etc. So far it looks good. Definetely better than the SQL Replication in 2000. Need to get used to the Replication Monitor though. The 2000 Repl monitor was pretty straight forward.



    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************

Share This Page