Unsolved
This post is more than 5 years old
3 Posts
0
357
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.
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.
0 events found
No Events found!
yito1
262 Posts
0
March 13th, 2008 19:00
Alias can select only one target.
Therefore, your scenario cannot be achieved.
Yoshinobu
Natha1
3 Posts
0
March 13th, 2008 22:00
Is it possible to do one to many replication.
yito1
262 Posts
0
March 14th, 2008 00:00
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