Wednesday, May 25, 2011

SQL 2008 R2 / Windows 2008 R2 Cluster install

Discovered there are two options for installation of an SQL 2008 R2 in a Windows 2008 R2 Cluster.  We currently install with option 1.  Here's a description of both options:

Option1:   Integration Installation with Add Node

SQL Server integrated failover cluster installation consists of the following steps:
·    Create and configure a single-node SQL Server failover cluster instance.  When you configure the node successfully, you have a fully functional failover cluster instance.  At this point, it does not have high availability because there is only one node in the failover cluster.
·    On each node to be added to the SQL Server failover cluster, run Setup with Add Node functionality to add that node.

Option 2:   Advanced/Enterprise Installation

SQL Server Advanced/Enterprise failover cluster installation consists of the following steps:
·     On each node that will be a possible owner of the new SQL Server failover cluster that you are creating, follow the Prepare Failover Cluster setup steps that are listed in the Prepare section.  After you run the Prepare Failover Cluster on one node, Setup creates the Configuration.ini file that lists all the settings that you specified.  On the additional nodes to be prepared, instead of following these steps, you can supply the auto generated Configuration.ini file from first node as an input to the Setup command line.  This step prepares the nodes ready to be clustered, but there is no operational instance of SQL Server at the end of this step.
·    After the nodes are prepared for clustering, run Setup on one of the prepared nodes, preferably on the node that owns the shared disk that has the Complete Failover Cluster functionality.  This step configures and finishes the failover cluster instance.  At the end of this step, you will have an operational SQL Server failover cluster instance and all the nodes that were prepared previously for that instance will be the possible owners of the newly created SQL Server failover cluster.

From technet

No comments:

Post a Comment