SQL Server 2016 active/passive cluster with availability groups to third server

Phillips, Keith 701 Reputation points
2021-11-02T19:12:15.1+00:00

In a setup of a two-node (active/passive) SQL Server 2016 cluster, is it possible to use Availability Groups to replicate the cluster databases to a third node on a different subnet? All three servers would be Win2019 in an FCI.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,490 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-11-03T02:59:26.737+00:00

    Hi PhilipsKeith-1816,

    Yes, I think it is feasible.
    But note that only one FCI partner can host a replica for a given availability group. When an availability replica is running on an FCI, the possible owners list for the availability group will contain only the active FCI node. And FCIs do not support automatic failover by availability groups, so any availability replica that is hosted by an FCI can be configured for manual failover only.
    Please refer to Prerequisites and Restrictions for Using a FCI to Host an Availability Replica and Failover Clustering and Always On Availability Groups which might be helpful.

    Best Regards,
    Amelia


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Alex Bykovskyi 1,681 Reputation points
    2021-11-05T15:46:01.7+00:00

    Hey,

    The following guide should help with configuration:
    https://www.starwindsoftware.com/resource-library/starwind-virtual-san-sql-server-hadr-using-availability-groups-and-failover-cluster-instance/

    In addition, you can use StarWind VSAN as a shared storage to configure SQL FCI:
    https://www.starwindsoftware.com/resource-library/starwind-virtual-san-installing-and-configuring-sql-server-2019-tp-failover-cluster-instance-on-windows-server-2016/

    Cheers,
    Alex Bykovskyi
    StarWind Software
    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose