SQL Server – Enable SQL Server 2012 AlwaysOn Availability Groups

In the previous post  SQL Server – AlwaysOn Availability Groups, described enhancement to SQL Server 2014 AlwaysOn Availability Groups. In this post, we will see how to enable SQL Server 2012 AlwaysOn Availability Groups using UI and PowerShell. Using UI Go to SQL Server Configuration Manager >> Navigate to SQL

» Read more

SQL Server – AlwaysOn Availability Groups

Introduction Microsoft introduced the AlwaysOn Availability Groups which is a high-availability and disaster-recovery solution that provides an enterprise-level solution in SQL Server 2012. Using Database Mirroring for local high availability and combining it with Log Shipping for a disaster recovery solution is popular deployment architecture prior to SQL Server 2012.

» Read more