Forum Discussion
Update on a failover cluster
Hi, i have some FailOvercluster in sql2017 and sql2022 .. I need to apply update (cu, sp pack?) and i have a question:
- where i apply patch, on physical server or in each instance of the cluster ?
Thanks
5 Replies
- where i apply patch, on physical server or in each instance of the cluster ?DAsnar13 , that's a bit strange question; where do you see a difference?
Procedure is:
- Apply SP/CU on the passive cluster node
- Perform a manually failover switch, active node becomes passive and verse vice
- Apply SP/CU on the now passive cluster node
- Hi, "where i apply patch on physical server or in each instance of the cluster ?" My question is because a have a two physical node with four sql instance ..
Thanks- Then you have to apply SP/CU for each of the 4 instances separately and this ons all 2 nodes.
Hello DAsnar13
When applying SQL Cumulative Updates to Clusters (AG or FCI) you always have to start by the passive node(s) or Read-only Replicas . here is link for you to follow
SQL Server patching in Windows Cluster Failover + Availability Groups – SQLServerCentral Forums
Regards
Javier
