SQL Server Availability Group without Cluster And AD In Windows

SQL Server Availability Group without Cluster – Dear DBAs, Do you think is this possible? Luckily yes, its possible to create an availability group without a Windows Failover Cluster on Windows. But unfortunately, there are few restrictions. Also, we don’t need to restore the Database on secondary. The availability group has a feature called Automatic Seeding to restore the database automatically from the Primary server.

Limitations:

1. There is NO AUTO Failover.
2. It’ll work on Windows Server 2016 + SQL Server 2016 or higher.

But yeah, its really a great feature for Read Scale. Lets see how can we configure the availability group without the WSFC.

My PoC Setup:

1. Windows Server 2016.
2. SQL Server 2017 Developer Edition.

FULL ARTICLE: https://www.sqlgossip.com/sql-server-availability-group-without-cluster-in-windows/