0

I have a 3 nodes cluster in an availability group. There are two databases on the primary node. One database I want to replicate to the 2 secondary nodes. Another database I just want to replicate it to 1 secondary replica, not the other. In the wizard, you have to select both nodes. Is there a way to set it up using T-SQL so that one database only replicate to one secondary node, but not the 3rd node?

Thanks!

  • If you're using them differently, why do they need to be in the same availability group? Just create two different groups... – Aaron Bertrand Jun 25 '15 at 20:27
0

You can setup 2 different availability groups and add databases accordingly, so that way you can manage it separately.

  • Can I share the AG listener? It's having error 41009 when tried to add it. – daisy Jun 26 '15 at 18:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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