Hi Friends,

Continuing my series of blog posts on SQL Server Failover Cluster, today I want to quickly show how can you initiate a manual failover of SQL Server service?

Connect to Failover Cluster Manager (Server Manager -> Features -> 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.

1_SQL_Server_Failover_Cluster_Initiating_Manual_Failover

Right click the service and click on the options as shown in the image…

2_SQL_Server_Failover_Cluster_Initiating_Manual_Failover

You will be prompted to confirm. Select to Move..

3_SQL_Server_Failover_Cluster_Initiating_Manual_Failover

Within a few seconds (of course, in real production environment the time factor may be different), you should see a failover to node 2, which can be verified as done previously.

4_SQL_Server_Failover_Cluster_Initiating_Manual_Failover