manually failover

http://www.sqlservergeeks.com/sql-server-failover-cluster-initiating-manual-failover/

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.