SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Is it possible to configure AlwaysOn AG between 2 standalone instances?
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.