Category Archives: Clustering

Setup LAB: 06 Installing Windows Failover Cluster to setup AlwaysOn


In the last post, I had configured the iSCSI target service to share the disk between two servers. I am going to use those two servers as Windows server Failover Cluster nodes and setup AlwaysOn availability group using that. To … Continue reading

Posted in AlwaysOn, Clustering, How To, Setup LAB, SQL2012, TestLab | Tagged , , , , , | Leave a comment

Setup LAB: 05 Configuring the iSCSI Target


In the previous post, I had installed the iSCSI Target service and create the volume using File and Storage Service. In this post, let’s configure the iSCSI Target Service. To begin with, open Server Manager, expand File and Storage Service … Continue reading

Posted in AlwaysOn, Clustering, How To, Setup LAB, SQL2012, Storage Server, TestLab | Tagged , , , , , , | 1 Comment

Setup LAB: 04 Setting up a Storage Server


Whenever we setup a Cluster in a LAB environment, often the biggest challenges in the whole process is, how to configure the storage server. A user reported that, the configuration steps mentioned on my blog for the FreeNAS server is … Continue reading

Posted in AlwaysOn, Clustering, How To, Setup LAB, SQL2012, Storage Server, TestLab | Tagged , , , , , , | 1 Comment

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