SQL Server 2017 introduces read-scale availability groups without a cluster. If your business requirement is to conserve resources for mission-critical workloads that run on the primary replica, you can use read-only routing or directly connect to readable secondary replicas. You don't need to depend on integration with any clustering technology. These new capabilities are available for SQL Server 2017 running on both Windows and Linux platforms. Without a cluster, SQL Server can't provide the low recovery time objective (RTO) that an automated high-availability solution provides.
. GeoPITS brings you the comprehensive details of Cluster-less availability group's support in different versions & editions of SQL Server.| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | |||
| Version v2017 | |||||
| Version v2016 | |||||
| Version v2014 | |||||
| Version v2012 |
SQL Server 2017 introduces read-scale availability groups without a cluster. If your business requirement is to conserve resources for mission-critical workloads that run on the primary replica, you can use read-only routing or directly connect to readable secondary replicas. You don't need to depend on integration with any clustering technology. These new capabilities are available for SQL Server 2017 running on both Windows and Linux platforms. Without a cluster, SQL Server can't provide the low recovery time objective (RTO) that an automated high-availability solution provides.
You can find more details about this version here
Back to all features