Forum Discussion

Copper Contributor

Jan 18, 2024

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 ?...

olafhelper

Bronze Contributor

Jan 19, 2024

- 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

DAsnar13

Copper Contributor

Feb 14, 2024

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

olafhelper
Bronze Contributor
Feb 15, 2024
Then you have to apply SP/CU for each of the 4 instances separately and this ons all 2 nodes.
- DAsnar13
  Copper Contributor
  Feb 19, 2024
  Hi, are you sure i need to install SP/CU on each instances ?