Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This is for SQL Server 2012. I currently have two datacenters that have separate SANs. I'm using failover cluster instances (FCIs) for server redundancy, and then AlwaysOn Availability Groups (AGs) for datacenter redundancy. This is what it looks like:

enter image description here

The problem is that I'd like FCIs at both datacenters, like so:

enter image description here

When we try to add the storage for Nodes3&4 we can't because the storage is not shared with Nodes1&2. At Add Storage to a Failover Cluster it says:

The disk must be available to all nodes in the cluster before you can add it to the set of storage for the cluster.

It is my understanding that Nodes1,2,3,4 must all be in the same Windows Failover Cluster in order to use AGs. However, this requirement seems to prevent us from being able to setup FCIs in both datacenters.

Is there any way to have my cake and eat it to?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

I've found the answer to this problem. It is possible, but you either need Windows 2008R2 SP1 or higher, or a hotfix. The full details are at:

AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and Availability Groups

To quote a line from this article: This arrangement of storage, where a cluster disk is shared between a subset of nodes within a WSFC, is referred to as asymmetric storage

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.