I learned today that SQL 2008 will actually not install by default in many multi-site cluster solutions. Why? Well, during the SQL 2008 installation, it runs through a Configuration Checker where one of the tests the environment to ensure that the cluster is configured properly. In a geographically dispersed cluster (specifically in an SRDF/CE cluster) this check will fail with the error: The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available. Doing a little bit of research on this might lead you to the MSKB … Continue reading SQL Strikes Again
I was informed that feedback for Microsoft product groups should be done through the http://connect.microsoft.com page. So I’ve submitted a request to add support for clusters running multiple subnets here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=353894 Please feel free to join in and rate/add your comments to my submission. Let the SQL team know that this is something that they need to address.
One of the great new features of Windows 2008 Failover Clustering is the removal of the “same subnet” restriction. This is a huge feature for multi-site clusters as I personally know of several customers that did not implement a multi-site cluster specifically because of this limitation. Most of the folks that I spoke with at TechEd are excited about this new feature and are considering multi-site clusters specifically because of this change. Anyway, at TechEd this year the SQL folks made it publicly known that SQL 2008 will NOT support clusters with nodes running on different subnets. Ouch! This is … Continue reading SQL 2008