Common issues faced while configuring AlwaysOn listener on Azure VM cluster

We have MSDN article [Tutorial: Listener Configuration for AlwaysOn Availability Groups (http://msdn.microsoft.com/en-us/library/dn425027.aspx) which provides detailed steps to configure AlwaysOn listener on Azure VM cluster. This article provides steps that can be followed to resolve commonly faced issues. Important consideration: All SQL Server virtual machines on Azure should be in the SAME cloud service for AlwaysOn…

0

How to move databases configured for SQL Server AlwaysOn

How to move databases configured for SQL Server AlwaysOn   This article describes how to change the location of the data files and the log files for any Microsoft SQL Server 2012 database which are configured with SQL Server AlwaysOn with minimal downtime. Considerations We have three node windows 2008/2012 cluster where SQL server is…


How to configure Always On for a TDE database

Creating Availability group for an Encrypted database:  In this blog we will walk you through the steps to create availability group for an encrypted database. Though we have various articles, I would like to keep the entire step by step approach in one place.   We cannot create an availability group for an encrypted database…


INF: AlwaysOn – The secondary database doesn't come automatically when the primary instance of SQL Server goes down

In this blog we would discuss about behavior of AlwaysOn availability group where the secondary database doesn’t come automatically when the primary instance goes down. The secondary database goes into Resolving state. On the failover cluster manager the resource appears in fail state. While doing some research, we found that if we stop SQL Service manually…

2