Post reply

SQL2000 Cluster and server reboot after windows updates

  • August 23, 2005 at 9:58 am

    #90787

    Hi all,

    We have a two node (active/active) SQL2000 cluster. Is the following procedure correct for server reboot after windows updates are applied? 

    Do windows updates on Node1, move group from virtual Node1 to virtual Node2, take virtual Node1 offline, reboot Node1, move group back to virtual Node1 from virutal Node2.

    Repeat the same on Node2 later.

    Please clarify if these steps are right.

    Thanks,

    srimath

  • August 23, 2005 at 11:54 am

    #584316

    Any response please?

  • August 24, 2005 at 12:41 am

    #584483

    What version of Windows?

  • August 24, 2005 at 7:55 am

    #584587

    dharper3, it's Windows 2000 Adv.server.

  • August 24, 2005 at 8:46 am

    #584616

    Your process sounds good to me, however I don't think you need to bring anything offline.  I would just move the SQL group to the next node before rebooting.

    Dylan Peters
    SQL Server DBA

  • August 24, 2005 at 10:55 am

    #584697

    I agree that it's not necessary to take the node offline once you have moved the group to the other node.  We have an active / passive setup, but the steps are basically the same.

  • August 24, 2005 at 12:43 pm

    #584744

    Look at http://support.microsoft.com/default.aspx?scid=kb;en-us;174799  It gives the general procedure for service packs and/or hotfixes in a clustered environment.

    JG

Viewing 7 posts - 1 through 6 (of 6 total)

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