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.
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.