• Category: Microsoft

SQL 2014 Availability Group with Windows 2016 Cloud Witness

What this guide covers

This configuration will include 3 SQL replicas across two sites\subnets.  2 will be located in the primary location where 'automatic failover' will be configured.  This will allow the primary node to automatically fail over to the secondary node at the primary site much like a mirror does.  The third node will reside in the secondary location in the case of site failure and will require a manual failover.

Drawing

 

Add a comment

Read more: SQL 2014 Availability Group with Windows 2016...