Home Forums SQL Server 2014 Administration - SQL Server 2014 How to apply service pack update on SQL 2014 cluster environment without server downtime RE: How to apply service pack update on SQL 2014 cluster environment without server downtime

  • October 7, 2015 at 4:46 am

    #1831949

    vijayakumarn (10/7/2015)

    Hi,

    I wanted to apply SQL server 2014 service pack1 and CU1 & CU2 on a two node cluster environment without server downtime. Please suggest.

    Thanks

    You'll first need to apply service pack 1 and then the latest CU as these updates are cumulative (hence their name Cumulative Update 😉 )

    You will incur an outage at some point, however this can be minimal if you observe the following

    • patch all passive nodes first
    • ensure you remove any passive nodes from the possible owners list for the networkname resource, this will prevent a failover during patching
    • apply all required patches and if necessary reboot the passive nodes
    • when the passive nodes have been completed add them back to the networkname possible owners list
    • failover the running instance to one of the passive nodes
    • patch the node the remaining node that is now passive

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

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