Post reply

Reinstall of SQL on passive node due to incorrect install of SP4

  • February 12, 2015 at 1:52 pm

    #314580

    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.

    There is no way to unistall SP4. SQL must be unistalled on the passive node then repatched to SP3 to be the same version as the active node.

    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

  • February 19, 2015 at 10:39 am

    #1778714

    I suggest to do a 'Remove node' first on passive node.

  • 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" 😉

Viewing 3 posts - 1 through 2 (of 2 total)

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