SQL 2008 Multi Site Clustering
-
Tuesday, May 08, 2012 6:08 PM
Hi,
is it possible to create a two node cluster, one node at Main Site and 2nd node @ DR site?
All Replies
-
Tuesday, May 08, 2012 8:44 PM
Yes, it is called a multisite cluster. Microsoft's Symon Perriman has an excellent presentation on multisite clusters here.
http://technet.microsoft.com/en-us/edge/Video/hh133452
I also wrote a Step-by-Step series on multisite clusters here
David A. Bermingham, MVP, Senior Technical Evangelist, SIOS Technology Corp
- Proposed As Answer by Chirag Shah Tuesday, May 08, 2012 9:30 PM
- Marked As Answer by Stephanie LvModerator Monday, May 21, 2012 7:01 AM
-
Wednesday, May 09, 2012 3:05 AMModerator
In addition to David's response, if you are using SQL Server 2008 R2 and below, multi-site cluster is not supported natively without having to implement a stretched VLAN. However, SQL Server 2012 AlwaysOn Failover Clustering now supports multi-subnet clusters natively.- Marked As Answer by Stephanie LvModerator Monday, May 21, 2012 7:01 AM
-
Wednesday, May 09, 2012 11:19 AMAs well as SteelEye there are a number of other storage vendors that support multi-site failover cluster. e.g. EMC, IBM, HDS, HP etc.

