Post reply

Replicate 3 Servers

  • May 1, 2012 at 5:23 am

    #255604

    Hello all,

    Currently I have three SQL Servers Instanced installed at the same computer.

    Please have a look at the assumptions below

    1- We have 3 instances on the same computer

    1.1 - NY-Office

    1.2- WA-Office

    1.3- CA-Office

    2- In each instance we have single database”DB1”

    3- In each”DB1” database we have Table called “CustomersTable”

    The scenario I want to do by replication is to replicate the data (inserted or changed) among all instances

    The replication result must show the all customer entered (or changed) from any instance

    I know how to configure the sql server publication, distributor, and articles, but I need the steps order please

    For example :

    1. lunch to instance #1, and configure

    1.1. the distributor

    1.2. the publication …etc

  • May 1, 2012 at 6:07 am

    #1481705

    Have you read the excellent "Stairway" series on the site dealing with Replication?

    http://www.sqlservercentral.com/stairway/72401/

    Might be a good place to start!

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • May 1, 2012 at 2:01 pm

    #1482091

    :w00t:

    Thanks bro,

    I will read the entire articles first then if i faced any problem I'll see how can we resolve it

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply