In Part 1 of this series, I showed you how to prepare your multi-site cluster, including setting up the Node and File Share Majority Quorum.In Part 2, we saw a video example of how to integrate Steel Eye Data Keeper, one of the available cluster replication solutions, with failover clustering to configure a multi-site Hyper-V failover cluster.
After you have configured your basic cluster as described in Part 1 of my series, run the Data Keeper to install Steel Eye Data Keeper Cluster Edition on both nodes of the cluster.
So, for the time being, you will have to span your subnet if you wish to separate your nodes geographically.
Now that you have determined to deploy a multi-node SQL server cluster, here are the steps you will need to follow.
Please see the following KB article and apply the howfix to all cluster nodes.
SQL 2008 is very dependent upon MSDTC, so it is highly recommended that you cluster the MSDTC resource before you cluster your SQL resource.