October 11, 2005 at 6:49 am
is it possible to replicate between two sql servers behind an F5? I have two WebServers w/ SQL on them. if one WebServer is hit and updates the db, i need to replicate to the other WebServer. but this needs to go the other way as well for the 2nd webserver. i have created both of them to be distributor's and Subscribers to each other. I created the publications and i have pushed the subscriptions. Does anyone see problems, i can see one myself? I think data between them may go out of sink (so to speak). so im looking for the best possible solution! Or this may work, i am not a dba, just a good ole developer. But i need to get my servers behind the F5 quickly! Thanks in advance
October 14, 2005 at 8:00 am
This was removed by the editor as SPAM
October 19, 2005 at 3:48 am
the prob is with merge agent.
as u have made both of them distributor as well as subscriber of each other respectively, u NEED to run the merge agent from both the ends, else it wont update the data.
other than that u can try out making only on subscription and pull both databases into one. and just RUN "single" merge agent.
xpecting your straight forward reply on this solution.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply