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!

Improve this question
1
  • 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, 2015 at 20:27

1 Answer 1

Reset to default
0

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

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

Your Answer

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

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