Yesterday we were discussing about Windows clustering (here on will say “Clustering”) and realized that I have not blog much about clustering,

Here I will be considering 2 node clustering “Active -Passive” Clustering. the configuration and stuff here may varry depending upon the cluster configuration.also this is my understanding on clustering.

In this blog I am not going to detailed about the minimum requirement and configuration about clustering that will we discuss later. This blog is meant for general guideline about clustering.

It’s a windows cluster and on that we can add the resource to which we want failover (sql server). So we can failover any resource like sql server. Here we are discussing sql server failover.

Basic Requirements are:

Two Nodes : High end servers having similar configuration. (Memory/CPU)

Shared Storage device – SAN, we need a shared storage , which can be shared with both the nodes.