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?


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

1 Answer 1


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
    Commented Jun 26, 2015 at 18:44

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.