i have a question concerning the installation of sql server updates on a sql server 2012 standard edition failover cluster.

For example a service pack installation. Is it possible to install the service pack at first on one node? And after the sucessfull installtion do the same thing on the other node? So that i have no downtime for the applications during the restart?



1 Answer 1


Yes, that is how we need to roll out patches in the sql cluster with minimum downtime. The downtime will be during the failover part.


  1. Patch the passive node first.
  2. Move the resources to the passive node.(This will become active now)
  3. Patch the current passive node.(It was originally active).

Before doing this do test it in a Test environment and prepare a full proof plan.

Also refer to this link :


  • 1
    There will be some short downtime during the failover.
    – Dan Guzman
    Dec 4, 2017 at 14:24
  • Yup, this is the best practise for a minimum downtime which will during the failover. Dec 4, 2017 at 14:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.