Share via

SQL Std Server 3 node HA and DR

KC P 1 Reputation point
2020-11-02T08:44:50.453+00:00

Hi,
As per SQL 2019 licensing policy, we can create 3 nodes with one set of SQL lic- one primary, one passive HA, and one passive DR. However, SQL Std license support only 2 nodes in either fail over cluster or basic availability group.
So, pls help me to understand how can we take benefit of 3 node setup with std version other than log-shipping?
Can we create a failover cluster of 2 nodes, make this cluster a member of BAG, and then add 3rd node as BAG member?
Any other suggestions welcome. Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,687 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shashank Singh 6,251 Reputation points
    2020-11-02T09:19:50.82+00:00

    Can we create a failover cluster of 2 nodes, make this cluster a member of BAG, and then add 3rd node as BAG member?

    Yes you can and this would be one of the way to have 3 nodes in WSFC. Please note a database residing in AG which is part of SQL FCI will not have automatic failover in BAG or AG. The feature gets removed as soon as you put AG as part of FCI.

    Also as I see adding 2 nodes with SQLFCI will only make things complex. What is issue with simple 2 node BAG ?

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.