Manual Failover Cluster

Manual Failover Cluster

Hi friends, in this post we will learn how to manual Failover SQL Server Cluster. Earlier we had learnt how to configure a two node SQL Server Failover Cluster.

Step by Step SQL Server 2008 R2 Clustering Part 1

Step by Step SQL Server 2008 R2 Clustering Part 2

Step by Step SQL Server 2008 R2 Clustering Part 3

Steps:

Go to Server Manager, Expand Features, And Expand Failover Cluster Manager.

Expand Services and Applications & select SQL Server service. You should be able to see the current owner of the service. In my example below, Node1 owns the service.

Right click the service and hover your cursor in move this service or application to another node, It give you an option Move to Node 2 click on the options as shown in the image.

You will be prompted to confirm. Select to Move. Confirm Node on which you want to Failover.

And your Node2 will take ownership.