Category Archives: SQL Server HA

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 I


Installation of Windows Cluster is always a challenging task. Most of the time, we didn’t get enough opportunities to install an entire cluster system on our own due to limitation of hardware/software. With the help of desktop virtualization software, now … Continue reading

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