0

I'm trying to set up an high availability architecture using merge replication. I have 3 databases, and I'm trying to keep them all up to date with merge replication.

So far I've manage to create one publisher and 2 subscribers, and all works fine...except when the publisher goes down.

So I thought about creating one more publisher and make the other databases also subscribe to it. I can do the publication normally, but when I create the local subscription, even though the GUI says it went successfully, the new subscription does not appear under "Local Subscriptions" folder.

Is this possible? or is it a limitation of sql server? (if it is possible...what may be wrong in my setup?)

regards

Improve this question
6
  • 1
    Replication is not "high availability" as mentioned in answers to your previous question dba.stackexchange.com/questions/7690/…. And now you ask for help on the wrong solution?
    – gbn
    Commented Nov 14, 2011 at 16:51
  • is this case of replication it also works as high availability, because if one server fails, the other ones are available to do the exact same work. I just want to know if this is possible, or if theres is any limitation (like one table only can subscribe one subscription)
    – RagnaRock
    Commented Nov 14, 2011 at 17:13
  • 1
    no, it isn't HA. It is replication. Do you publish the whole database?
    – gbn
    Commented Nov 14, 2011 at 17:15
  • @RagnaRock I feel like this is about the fourth time people have complained about your communication on this site. Is this something that we can help you resolve? If you do want help, please visit chat.stackexchange.com/rooms/179/the-heap and we can see what's going on.
    – jcolebrand ♦
    Commented Nov 14, 2011 at 17:18
  • this is replication, but replication can be used to achieve HA, as stated here. At this point I'm just testing this technology, with 3 SQL instances with just one table for testing purposes. If it goes well I plan to replicate the whole DB. I want to know if its possible to have a circular chain of merge replication between the 3 DB's. If it is...I'm not being able to do it, but I'm not having any explicit error, it's just not working
    – RagnaRock
    Commented Nov 14, 2011 at 18:32

2 Answers 2

Reset to default
4

What you are asking is not possible. Do not use SQL replication for high availability. It is an exotic and soon-to-be deprecated feature set.

Improve this answer
1
  • Brilliant. It's deprecated
    – gbn
    Commented Nov 15, 2011 at 19:32
0

well, its actually possible but with peer-to-peer replication too bad this is a enterprise edition feature only

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.