Home Forums SQL Server 2005 SQL Server 2005 General Discussion Reinstall of SQL on passive node due to incorrect install of SP4 RE: Reinstall of SQL on passive node due to incorrect install of SP4

  • February 19, 2015 at 1:33 pm

    #1778760

    NJDave (2/12/2015)

    Hello

    In SQL 2005 Standard, SP 4 was installed on the passive node of a cluster first. SP4 should have been installed on the active node first.

    Ideal that the SP is run from the active node but necessary.

    NJDave (2/12/2015)

    I have the install files on the passive node. My plan is to...

    uinstall SQL server from passive node

    install SQL Server on passive node

    patch to SP3 on passive node

    cluster service is stopped on the passive node

    My question is, after I install SQL and sp3 - will simply starting the cluster service on the passive node make the cluster work again? Is there anything else I need to do that wasn't included in my plan?

    Thanks

    Dave

    First try this,

    go into cluster administrator and pause the passive node, once the node has been paused run the SP on the active node, you'll need a reboot so be prepared. Once the SP has been applied resume the passive node in cluster administrator. Check the instance fails over between the nodes

    Let me know how you get on

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉