Published: Troubleshooting Guide for Availability Group Listener in Windows Azure

Before the holidays, this article was quietly published: http://msdn.microsoft.com/en-us/library/windowsazure/dn495646.aspx This is a troubleshooting guide for all those going through the joys and pains of configuring the availability group listener in the cloud. There are already guidance on how to configure the listener in Windows Azure or hybrid IT, but no known content that helps you…

1

Availability Group Listener in Hybrid IT: End-to-End PowerShell Script Published

Hello, Please check out the script at http://gallery.technet.microsoft.com/scriptcenter/Create-Availability-Group-3fc1ca5e. This script creates a listener for an availability group with replicas both on-premise and in Windows Azure. For information on how to configure the hybrid availability group listener without the script, see http://msdn.microsoft.com/en-us/library/dn425027.aspx. As always, feedback is welcome.

2

Availability Group Listener in Windows Azure Now Supported! (And Scripts for Cloud-Only Configuration)

If you haven’t noticed, AlwaysOn Availability Groups in Windows Azure now supports availability group (AG) listeners. Configuring the AG listener in Windows Azure is a multi-step process that includes: Creating a load-balanced endpoint for the Windows Azure VMs that host AG replicas. Ensuring that hotfix KB2854082 is installed on all cluster nodes (including any node…

5

AlwaysOn in SQL Server 2014 CTP1

Failover Cluster Instances as well as Availability Groups have some great features coming up in SQL Server 2014. Take a look at Luis’ post on what you can try out with publicly available CTP1: http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/27/alwayson-in-sql-server-2014-ctp1.aspx      

3

Test Lab: Create an AlwaysOn Availability Group in Windows Azure End-to-End

In this blog, you will learn how to configure AlwaysOn Availability Groups end-to-end using Windows Azure VMs. The steps here are the GUI near-equivalent of the script-based tutorial, which has been published at Tutorial: AlwaysOn Availability Groups in Windows Azure. The end-to-end test lab is designed to help you go through all the basic paces…

13

WSFC Cluster Configuration on Windows Azure Virtual Machines

Windows Azure Virtual Machines (VMs) are currently in preview at www.windowsazure.com. SQL Server high availability and disaster recovery solutions are supported on Windows Azure VMs. For AlwaysOn Availability Groups, there is currently no support for availability group listeners in Windows Azure. Also, you must work around a DHCP limitation in Windows Azure when creating Windows Server…

4

How To: Migrate to AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 2

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) This blog is the continuation of a blog series that shows you how to perform the following end-to-end HADR migration scenario of SQL Server inside a test environment: From a SQL Server 2008 R2 solution: Database mirroring for high availability and log shipping for…

0

How To: Migrate to AlwaysOn AlwaysOn from Prior Deployments Combining Database Mirroring and Log Shipping – Part 1

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) This blog series is a follow-up to my whitepaper Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping. In this series, I will walk you through the following end-to-end migration scenario inside a test environment: From a…

4

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 3

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) NOTE: SQL Server Failover Clustering has been renamed AlwaysOn Failover Cluster Instances (FCI) in SQL Server 2012. For simplicity, the term FCI in this paper applies to either SQL Server Failover Clustering in SQL Server 2008 R2 or AlwaysOn FCI in SQL Server 2012….

0

How To: Migrate from Failover Cluster Instances and Database Mirroring to SQL Server AlwaysOn – Part 2

Writer: Cephas Lin (Microsoft) Contributors: Oleg Bulanyy (Microsoft), Jimmy May (Microsoft) NOTE: SQL Server Failover Clustering has been renamed AlwaysOn Failover Cluster Instances (FCI) in SQL Server 2012. For simplicity, the term FCI in this paper applies to either SQL Server Failover Clustering in SQL Server 2008 R2 or AlwaysOn FCI in SQL Server 2012….

0