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!