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.

Manual Failover Cluster, how to Manual Failover Cluster in SQL Server, SQL Server Manual Failover Cluster, Manual Failover Cluster in Windows Server 2008 r2

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.

Manual Failover Cluster

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

Manual Failover Cluster

And your Node2 will take ownership.

One thought on “Manual Failover Cluster

Comments are closed.