Start a Conversation
UNSOLVED

Natha1

updated

18 years ago

N

Natha1

3 Posts

0

362

March 13th, 2008 05:00

One To Many SQL Replication

Can i do a One to Many Replication. I have following Scenario:-

Source & Target Servers in same location with Alias configured & working properly but now i want to replicate to another Target Server at different location over WAN.
Is it possible with failover?

Can i have the Same Alias name for LAN & WAN Replication? & if possible can i prioritize the Alias failover.

LAN Failover should only occur & in case of complete site disaster WAN failover should happen.
  • Y

    yito1

    262 Posts

    172

    0

    Posted March 13th, 2008 19:00

    Hi,

    Alias can select only one target.
    Therefore, your scenario cannot be achieved.

    Yoshinobu
  • N

    Natha1

    3 Posts

    172

    0

    Posted March 13th, 2008 22:00

    Then how can i achieve the above scenario.

    Is it possible to do one to many replication.
  • Y

    yito1

    262 Posts

    172

    0

    Posted March 14th, 2008 00:00

    Hi,

    Your scenario cannot be achieved with RepliStor.
    The precondition of Alias is one to one.

    If AutoStart is combined with RepliStor, your scenario will become possible.

    Yoshinobu

Dell Support Resources

Latest Solutions

View More