Solved

MS SQL Server 2012 Multi Site Clustering

Posted on 2013-01-23
1
735 Views
Last Modified: 2013-01-23
Scenario

I have  2 sites on 2 different subnets.  I have Windows 2012 and SQL 2012 Enterprise edition.

There is a SAN on  the primary site and one on the DR Site.

If a cluster is configured on 1 site I know how the storage would be configured.  

How does this work across the 2 sites how do you configure the shared disks?.

How does the failover work?

I have seen so many conflicting articles on this.  rather than point to others if you could simply comment that would be great.

Thanks.
0
Comment
Question by:ProjNet
1 Comment
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 400 total points
ID: 38809808
Here is a great document about exactly what you are talking about:
http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/SQLServer2012_MultisiteFailoverCluster%20(2).docx

The major hurdle and key to multi-site failover is the storage devices. The SANs need to replicate to each other and have the ability to support failover to the other device.

This is key because you would not normally have a DR site that reaches back to the Primary site, since in a disaster, there is not going to be a Primary site any longer. So Storage replication is important and this is handled by the SAN.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question