Post reply

SP3 for SQL Server 2005 on cluster tips

  • September 16, 2009 at 9:43 am

    #209939

    I have SQL Server 2005 installed on Active/Passive clusters.

    Now as SQL Server is on Active node. Can someone give me the steps by step details how to install SP3 on the cluster environment.

  • September 16, 2009 at 10:50 am

    #1054606

    any ideas friends?

  • September 16, 2009 at 11:29 am

    #1054630

    1. Connect remotely to the first node of cluster through the Terminal Services by physical box name

    2. Copy installation package to the local drive

    3. Install SP3

    4. Reboot a box

    5. Verify that box is back

    6. Repeat steps 1-5 for the second node

    6. Enjoy 🙂

  • September 16, 2009 at 11:34 am

    #1054634

    but when i restart after installing on the first node. do i still need to install SP3 on the second node, because SQL server will be running on node one only?

  • September 16, 2009 at 11:44 am

    #1054641

    Yes, because you want to provide a seamless failover.

  • September 16, 2009 at 11:47 am

    #1054642

    ...but when i restart after installing

    I hope you mean not just restarting services. Whole physical box should be rebooted because SP3 updates Windows registries, it is important.

  • September 16, 2009 at 12:28 pm

    #1054666

    Since it is an Active/Passive cluster, you can Install the SP3 on the Active node (where SQL running on), so cluster will take care of the installation on both nodes.

    After installation both nodes (Physical boxes) require a reboot, you can do one by one or can reboot them simultaneously.

    Once the servers come back, ensure that the expected SQL version on both nodes. For that check the SQL version on Active node first and then failover the SQL group to the next node and check the SQL version again.

    Hope this makes sense...

    Thanks

    Jay

    Thanks
    Jay
    http://www.sqldbops.com

  • September 16, 2009 at 1:03 pm

    #1054681

    yes that give me some more idea.

    Thanks.

  • September 16, 2009 at 1:12 pm

    #1054684

    You have to run the service pack on all nodes in the cluster to upgrade the non-cluster aware services that exist on each node. For example, SSRS/SSIS will not be upgraded on each node.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 9 posts - 1 through 8 (of 8 total)

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