Steps for manual failover on a cluster

Question

_{Thursday, February 11, 2016 8:52 PM}

Hi All,

I've just started my training as an SQL DBA and I would like to know what the proper steps are for failing over a cluster. To test this I have build a 2 node test Cluster can you please advise which steps I should take to manually failover all resources to the passive node.

e.g. do I fail over storage first then Roles then cluster group. 

Please advise thanks

Robert

All replies (4)

_{Friday, February 12, 2016 1:12 AM ✅Answered}

Hi Robert,

Considering the two posts are the same, I would merge them into a single post.

For general clustered service, here is the guide:

https://technet.microsoft.com/en-us/library/cc754577.aspx

If you want to perform a planned manual failover of an AlwaysOn SQL availability group, here is the guide:

https://msdn.microsoft.com/en-us/library/hh431018.aspx

For more details, you could also post in the SQL HA forum:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqldisasterrecovery

Best Regards,

Leo

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact [email protected].

_{Friday, February 12, 2016 1:58 PM ✅Answered}

To manually failover all resources from one node to another ...

In the Failover Cluster Management console, right-click on the node you want to clear of resource, select Pause > Drain.

. : | : . : | : . tim

_{Thursday, February 11, 2016 8:54 PM}

Hi All,

I've just started my training as an SQL DBA and I would like to know what the proper steps are for failing over an

Hi All,

I've just started my training as an SQL DBA and I would like to know what the proper steps are for failing over an availability groups. To test this I have build a 2 node test group can you please advise which steps I should take to manually failover all resources to the passive node.

e.g. do I fail over storage first then Roles then cluster group. 

Please advise thanks

Robert

_{Friday, February 12, 2016 7:28 AM}

Thanks Leo I have followed the steps above however once I fail over the roles using the I then need to failover "Cluster group" and "available storage" separately. Can you please advise the correct order to fail each part of the cluster over.