December 3, 2024 at 3:34 am
Hi Team,
I am planning to apply security updates for SQL Server 2016 on Active/Active Cluster servers. Could you please advise on the proper procedures to follow? Specifically, which server should I apply the updates to first, and when should I reboot the servers? Your guidance would be greatly appreciated.
Thanks
December 4, 2024 at 4:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 4, 2024 at 6:36 pm
Do you mean that you have 2 nodes and workloads running against both (different dbs on each)? Is this a WSFC?
First, you should copy the db(s) to another system running the same Windows and SQL Server versions. Patch that and then test to be sure your application still runs and can connect.
If node 1 can handle both workloads, fail over from node 2, then patch node 2. Then fail everything to node 2 and patch node 1. There's no magic here.
What I would actually recommend is add a node 3 (https://learn.microsoft.com/en-us/sql/sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup?view=sql-server-ver16) and then patch that. Fail over node1 to node 3, patch node 1, then fail over node 2 to node 1 and patch node 2. Roll through your systems
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply