How to Set Up SQL Server 2012 AlwaysOn Availability Groups

Advantages

• fail over automatically
• ability to run reports on the live database
• Run backup on standby server

Prerequisites

• 2 Windows Server 2008 R2 Enterprise servers
• NET Framework 3.5.1 feature
• Failover Clustering feature

Steps

• Configure Failover Cluster Manager.
• Join 2 servers to the the same domain
• Create Cluster Wizard
• Install SQL Server stand-alone installation
• In Configuration Manager, enable AlwaysOn by clicking SQL Server Services