How to Create a SQL Server 2016 AlwaysOn Availability Group- step by step
Copied from the below article http://www.macaalay.com/2016/11/04/step-by-step-easy-instructions-on-how-to-create-a-sql-server-2016-alwayson-availability-group/ ------------------------------------------------------------------------------------------- SQL Server AlwaysOn Availability Group has been existing since SQL Server 2012 and its one of the best features SQL has to offer, while I haven’t used it in production since it was launched I tried using it for only testing but now that we have an Enterprise License we can use it in Production and enjoy all the other benefits of the Enterprise License . With SQL Server AlwaysOn it high availability and disaster recovery to a different level by making multiple copies of the database highly available and even use them as read-only workloads to be used on reporting, backups and other management tasks. With this technology it allow you to fail over a group of databases as a single entity unlike how we did it before with database mirrorin