AG between 2 standalone instances?

Chaitanya Kiran 756 Reputation points
2022-03-25T13:43:25.667+00:00

Is it possible to configure AlwaysOn AG between 2 standalone instances?

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,067 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 103.5K Reputation points MVP
    2022-03-25T22:25:38.963+00:00

    Yes, starting with SQL 2017 you can set up an AG between machines that are not in a cluster by specifying CLUSTER_TYPE = NONE when you create the AG.

    This kind of setup is sometimes also know as a read-scale group, as the main intention is give you the benefit of a readonly secondary.

    In a cluster-less AG, the replicas must be asynchronous and failovers are manually. A clusterless AG cannot be considered to be an HA solution, but it certainly can serve as a DR solution.

    0 comments No comments

0 additional answers

Sort by: Most helpful