Hello,
just like the subject says, is it possible to have 1 node belong to 2 different always on availability groups?
there is 2 things though...
so here is the setup
SQL Server A - on Domain 1, this has always on group 1 primary
SQL Server B - on domain 1, which will be the read only/secondary for both always on if possible
SQL Server C - on a different domain, called domain 2, which is the primary for always on group 2.
i would like it if B can belong to always on group 1 and 2, as the secondary read only, not a fail over of course, is this possible?