Post reply

How to do manual failover for sql server cluster 2008

  • November 21, 2011 at 8:17 am

    #248141

    Hi All,

    I have very interest to know how to do manual failover for sql server cluster 2008?

  • November 21, 2011 at 8:20 am

    #1410754

    stop the service on the server which has the active cluster node would be easiest,

    from there you get ideas like unplugging the network cable, turning on the firewall to block it's traffic, rebooting the server,

    ignore the posts suggesting getting out the hammer and smashing things....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 21, 2011 at 9:39 am

    #1410850

    open up cluster manager, find the resource group you want to move, then click move resource and tell it which node in the cluster you want to move it to.

    this stops anything in the resource group cleanly, moves it over, starts it up, clean manual resource group failover

  • November 22, 2011 at 12:18 am

    #1411221

    ignore the posts suggesting getting out the hammer and smashing things....

    Best advice... LOL :hehe:

  • November 23, 2011 at 11:14 am

    #1412378

    ssk0507 (11/21/2011)

    Hi All,

    I have very interest to know how to do manual failover for sql server cluster 2008?

    Killing\disabling the Public network connection is a good place to start, also move the groups as previously mentioned

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply