SQl 2005 Cluster Sp3 appears again again on passive node

Discussion in 'microsoft.public.sqlserver.clustering' started by Thomas Leinberger, May 6, 2009.

  1. Dear It Pros,

    i've installed Sp3 for SQL 2005 on a 2 Node A/P cluster. I paused the 2nd
    Node and installed successfully SQL Sp3 on the first and active node. I
    restarted the first node. After reboot i "unpaused" 2nd Node and installed
    SQl 2005 SP3 successfully , but suddenly it appears again for installation, i
    can install it successfull but it asks verytime. i tried moving all
    resourcegroups to 2nd node and
    SP3 failed to install. Moving back the resources to Node 1 the installation
    succeeded.
    Any Ideas ? thank you in advance
     
    Thomas Leinberger, May 6, 2009
    #1
    1. Advertisements

  2. SP3 is a cluster-wide install. It doesn't deal well with node-by-node
    installation.

    Leave both nodes on and apply the SP3 and see if that resolves your issue.
     
    Geoff N. Hiten, May 7, 2009
    #2
    1. Advertisements

  3. Hi Geoff,

    thank you for your answer. This moring i made Node2 active,

    stopped Windows Update Service (wuauserv) deleted the
    C:\windows\softwaredistribution Folder and started the wuauserv again,
    and nothing happens since that. I started wuauclt /detectnow to force
    Windows Update detection but it seems that it works now.
    Node 1 was paused due to MS Security Update installation from April and
    restarted.

    Yesterday i left both nodes on as you suggested and installed the SP3 on
    Node2 , it was installed successfully but after 2 minutes it asks again to be
    installed.

    Have a nice day
    BR
    Thomas
     
    Thomas Leinberger, May 7, 2009
    #3
  4. Thomas Leinberger

    Uri Dimant Guest

  5. Thank you Uri for the reply,

    i found that my problem still exists. I moved the resources on the second
    node
    and try to install sp3, the wizard comes up bit it stops the installation
    when he found "locked files". This was crazy, only Database Service needs to
    update but it was updated on the first node already.
    btw on the second node there is a installation of "Performance Dashboard"
    this is the only difference between these nodes.

    Thank you
    BR
    Thomas
     
    Thomas Leinberger, May 25, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.