Post reply

SP on cluster

  • May 21, 2013 at 5:43 pm

    #394823

    We have an Active-Passive SQL Server 2008 Failover Cluster installed. Front end is sharepoint.

    They have two instances on each cluster, one instance is named prod_mssqlserver, the other is for qa_mssqlserver.

    Now I need to apply service pack3 on it.

    Do I have to run it on both physical servers? And does each run will do the SP for both instances?

    We can take down both nodes for patch, do not need to do the failover for this purpose, shall I run the passive nodes first without taking down the active one?

    Then I can take down the active one to do the patch.

    Thanks,

  • May 21, 2013 at 10:56 pm

    #1617257

    You need to patch both physical servers, starting with the passive nodes. When you run the SP, it will show both instances can be upgraded at the same time for that particular physical server. After upgrade, fail-over both instances and upgrade the other physical server.

  • May 22, 2013 at 10:01 am

    #1617501

    How can I manually fail over the node1 to node2?

    THanks,

  • May 22, 2013 at 5:12 pm

    #1617642

    RDP into either of the nodes and open Failover Cluster Manager, expand Services & Applications, right click each one and "Move this service or application to another node"

  • May 23, 2013 at 3:26 pm

    #1618052

    But I see it is grayed out.

  • May 23, 2013 at 5:28 pm

    #1618066

    What do you see when you expand Nodes

  • May 23, 2013 at 5:35 pm

    #1618068

    There are two nodes name there:

    one is CS1 and the other is CS2, CS1 is active, and CS2 has a red dot next to it, so means passive.

  • May 23, 2013 at 5:47 pm

    #1618070

    It should not have a red dot next to it. Is it a dot or a red down arrow?

    Right click on it and "show critical events for this cluster node". Is it running?

  • May 23, 2013 at 5:50 pm

    #1618071

    Sorry, it is a red down error, I didn't see it clearly.

    Is it safe I click show the critical events for this cluster node?

  • May 23, 2013 at 6:03 pm

    #1618072

    Yes it's safe to click, it's just a log file. The second node should be running but not running SQL, that's the definition of active-passive. An active-active would be running 2 instances of SQL, one on each server.

    The second node should be running, otherwise whats the point of the cluster?

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

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