SQL Server Performance

Replication Between Three Servers

Discussion in 'SQL Server 2008 Replication' started by RVG, Sep 1, 2011.

  1. RVG Member


    In our environment we are planning to set up replication betwen three servers with publisher running on SERVER A, Distributor on Server B, Subscriber on Server C. Can this be done? If yes can anyone share me the documents with me?


  2. preethi Member

    This can be done. In fact, this is one good way if both your publisher and subscriber are busy servers.
    1. Please make sure Server B can see Server A & C
    2. You need to configure Server B as the distribution server (When you configure the server for replication with local distribution, it will create distribution database there.)
    3. On Server A, when configuring for replication, you need to use remote distributor - pointing to Server B
    4. Now create the publication and then the subscription.
    5. Make sure you create appropriate access rights for repldata folder and the accounts used by replication agents.
    6. Please refer books online for more details. One good book on this topic is "Pro SQL Server 2008 Replication" http://www.amazon.com/Server-2008-Replication-Experts-Voice/dp/143021807X
  3. preethi Member

Share This Page