Post reply

Always on Availability Groups 1 node belonging to 2 always on groups if possible?

  • December 11, 2018 at 10:14 am

    #378799

    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?

  • December 19, 2018 at 2:28 pm

    #2016896

    "A cluster node can host one replica for an availability group. The same node cannot host two replicas from the same availability group. The cluster node can participate in multiple availability groups, with one replica from each group."

    Taken from:

    https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability?view=sql-server-2017

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply