What is the difference between Always On Clustered and Always On Clusterless

What is the difference between Always On Clustered and Clusterless? How do these High Availability solutions relate to read-only replicas? Read more →

How to get Cluster File Share Witness sharepath with Powershell

How to get Cluster resource information such as Cluster File Share Witness sharepath Read more →

How to get the Always On Availability Group DNS name per database

Find the Clustered Always On database DNS Read more →

How to restore Always On Availability Group databases

Get instructions to restore Always On Availability Group databases Read more →

How to force failover on Clusterless Availability Groups with FORCE_FAILOVER_ALLOW_DATA_LOSS

Clusterless Availability Groups are not true HA as there is no underlying cluster - and generally is intended as read only. I've also seen this set up being used in migration scenarios. Although not HA - it is still possible to commit a manual failover from a PRIMARY to SECONDARY. For example in a DR scenario Prior to commiting a failover identify the set up is a Clusterless Availability Group configuration . When the Clusterless Availability Groups was set up the command will be similar to the following CREATE AVAILABILITY GROUP command. Note: >> Here we connect to our primary... Read more →