Tuesday, May 08, 2012 6:08 PM
is it possible to create a two node cluster, one node at Main Site and 2nd node @ DR site?
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.
I also wrote a Step-by-Step series on multisite clusters here
David A. Bermingham, MVP, Senior Technical Evangelist, SIOS Technology Corp
Wednesday, May 09, 2012 3:05 AMModeratorIn 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.