Update on a failover cluster

[DAsnar13]

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

[#2]

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

[#3]

---

- 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

[#4]

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

[#5]

Then you have to apply SP/CU for each of the 4 instances separately and this ons all 2 nodes.

[#6]

Hi, are you sure i need to install SP/CU on each instances ?