Tag: AlwaysOn

SQL Server – Enable SQL Server 2012 AlwaysOn Availability Groups

SQL, SQL-Advanced, SQL-Server 2012, Varinder Sandhu

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 Server Service >> Right Click to SQL Server Service and Click to Properties Navigate to AlwaysOn High Availability tab >> Check the “Enable AlwaysOn Availability Groups ” check Box Using

» Read more
, , ,

SQL Server – AlwaysOn Availability Groups

SQL, SQL-Advanced, SQL-Server 2012, Varinder Sandhu

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. With SQL Server 2012, the Database Mirroring and Log Shipping solution can be replaced with an Availability Group solution with multiple secondaries. AlwaysOn Availability Groups – Deployment Architecture The whitepaper

» Read more
, ,