Category Archives: Clustering

Building a SQL Server 2008 R2 Cluster: Part VIII


As discussed in the previous part of this series, in a production environment you should never shut down a cluster as it failed the entire purpose of High Availability. However, the current series is focusing on learning purpose. If you … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , , | 2 Comments

Buliding a SQL 2008 R2 Cluster: Part VII


In the previous part of this series, we had installed the Failover SQL Cluster. In this post, we are going to add the second node to the existing cluster. To begin with, verify that all the resources are present on … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , | 1 Comment

Building a SQL Server 2008 R2 Cluster: Part VI


With Part-V of this series on Failover Cluster installation, the two-nodes windows 2008 cluster is up and running. Before continuing further, there is a small update on the installation prerequisites of SQL Server 2008 R2. The following three components are … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , | 2 Comments

Building a SQL Server 2008 R2 Cluster: Part V


In the previous part of this series, we have created the windows cluster and added the disk resources. In this post, we are going to re-configure the Quorum setting of this cluster, and then we are going to add the … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , | 5 Comments

Building a SQL Server 2008 R2 Cluster: Part IV


As of previous post, we have configured all the necessary parameters to start the Failover Cluster installation including dotnet framework 3.5. In this post, we are going to build the failover windows cluster on Windows Server 2008. I have started … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server HA, SQL Server Installation | Tagged , , | 3 Comments

Building a SQL Server 2008 R2 Cluster: Part III


In the previous part of this post, we have configured the disks for our Windows Cluster. The disks are created from a RAID 5 LUN. As you can see, we have a LUN of 60GB however only 40GB is available … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server Installation | Tagged , , | 5 Comments

Building a SQL Server 2008 R2 Cluster: Part II


In the first part of this series, we saw the installation of our storage server for our demo cluster environment. In this part, we are going to configure our storage server. Before we configure our storage server, we need to … Continue reading

Posted in Clustering, How To, SQL Server, SQL Server Installation | Tagged , , | 4 Comments