1

What are the steps to apply windows updates to a active/passive two node sql failover cluster? My initial thought was to apply windows updates to passive node/reboot and then failover and repeat process but not sure. Do I need to stop the db's and sql agent jobs before failover?

sql2014 windows 2012r2

1
2

You do not need to stop any jobs or services to manually failover. Please see the Microsoft Docs - Perform a Forced Manual Failover on manually failing over.

These are the general steps you should follow for applying any updates to your failover cluster instances:

  1. Backup all databases.
  2. Failover all SQL cluster roles to Node A.
  3. Install the patches on Node B (passive).
  4. Restart Node B.
  5. Failover all SQL cluster roles to Node B.
  6. Install the patches on Node A (passive).
  7. Restart Node A

More information on the installing updates process can be found in these Microsoft Docs - Upgrade a failover cluster instance.

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.