Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

share|improve this question
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 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
1  
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 chat.stackexchange.com/rooms/179/the-heap 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
show 1 more comment

2 Answers 2

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.