none
Steps for manual failover on a cluster RRS feed

  • Question

  • 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

    Thursday, February 11, 2016 8:52 PM

Answers

All replies

  • 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


    Thursday, February 11, 2016 8:54 PM
  • 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/hh231018.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 tnmff@microsoft.com.

    • Marked as answer by Robert Pollock Thursday, February 18, 2016 7:32 AM
    Friday, February 12, 2016 1:12 AM
    Moderator
  • 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.

    Friday, February 12, 2016 7:28 AM
  • 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

    • Marked as answer by Robert Pollock Thursday, February 18, 2016 7:32 AM
    Friday, February 12, 2016 1:58 PM