SQL Server Performance

Trouble installing a hotfix in a cluster

Discussion in 'Getting Started' started by Rick H., Nov 16, 2009.

  1. Rick H. New Member

    SQL Sever 2005 in a clustered environment. Printed out advice from Linchi Shea. Succesfully installed hotfix on Node A. When trying to install hotfix on Node B, stuck with message:
    "All features for this SQL Server 2005 instance must be updated together."
    Any advice???
  2. satya Moderator

    Welcome to the forms.
    What kind of hotfix you are referring?
    Do you have the number & relevant article?
  3. Rick H. New Member

  4. satya Moderator

    Did you followed as defined on the blog there?
  5. Rick H. New Member

    I followed it exactly... and everything looked fine until I switched to Node B.
  6. satya Moderator

    See the step: ....After node A has come back online, make sure that the SQL Server resource group is on node B. If not, move it there.......
    • Pause node A with Cluster Administrator.
    • Apply the service pack or hotfix on node B. Again, this should typically succeed (unless there is some other issue).
    • Un-pause node A, and reboot node B, if necessary.
    If you have followed this typically it should continue the process without fail, also read thru any supported text from that hotfix.
    As you said it fixed your problem, it means have you tested it anywhere?
  7. Rick H. New Member

    Guess I'll have to try the install again...
    Node A (my primary Node) is working fine and I can now generate reports that previously wouldn't work.
    Is there an install log somewhere that is generated that might give me some insight??
  8. satya Moderator

    Oh yes it will create an output file, such as see bold & red-color path I have specified below:
    The summary log (summary.txt) shows:
    Product Installation Status
    Product : SQL Server Database Services 2005 (MSSQLSERVER)
    Product Version (Previous): 4226
    Product Version (Final) :
    Status : Failure
    Log File : C:program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB970279_sqlrun_sql.msp.log
    Error Number : 29537
  9. Rick H. New Member

    That was a big help..
  10. satya Moderator

    Nae problemo, let us know whether the hotfix is done on all the nodes...

Share This Page