0

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?

Greetings

2

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.

Process:

  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 :

https://blogs.msdn.microsoft.com/john_daskalakis/2014/09/05/how-to-install-a-service-pack-at-a-sql-server-2012-failover-instance-best-practices/

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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