Setting up a two-node SQL Server 2008 Cluster from the Command Prompt

  • Article

1. Setting up a two-node SQL Server 2008 Cluster from the Command Prompt - Preparation

SQL Server failover clustering provides the best high-availability solution for an entire SQL Server instance. When the active node in a SQL Server cluster goes offline due to hardware problems, OS problems or scheduled reboots, the SQL Server failover instance configured on the cluster automatically fails over to another node and continues running there. With the release of SQL Server 2008 RTM, the installation process of SQL Server cluster has significantly changed. We have two options now. They are Integrated installation and Advanced/Enterprise installation. In the Integrated installation, we first create a single-node SQL Server failover cluster instance. Then we run Setup on each node that we want to add to the cluster, and add the node to the cluster using the Add Node functionality in Setup. In Advanced/Enterprise installation, we prepare each node in the failover cluster to join the cluster using the Prepare Failover Cluster functionality in Setup. After we prepare the nodes, we complete the failover cluster instance on the active node and make it operational using the Complete Failover Cluster functionality in Setup.

In part I of this series, I will show you how to prepare for SQL Server cluster setup.

The full article is here :

 

2. Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation  

In Part 2 of this series, we have illustrated how to install a SQL Server 2008 cluster using the Integrated Installation option. In the next installment, we will explore the Advanced Installation option.

3. Installing a Two-node SQL Server 2008 Cluster - Advanced option

 

image