Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?)


share|improve this question
Replication is not "high availability" as mentioned in answers to your previous question…. And now you ask for help on the wrong solution? – gbn Nov 14 '11 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 Nov 14 '11 at 17:13
no, it isn't HA. It is replication. Do you publish the whole database? – gbn Nov 14 '11 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 and we can see what's going on. – jcolebrand Nov 14 '11 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 Nov 14 '11 at 18:32
up vote 4 down vote accepted

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.

share|improve this answer
Brilliant. It's deprecated – gbn Nov 15 '11 at 19:32

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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