Forum Discussion

Martin_NZ's avatar
Martin_NZ
Level 2
5 years ago

Question on Applying SQL Patch in SQL veritas cluster

Hi everyone,

Good day!

Sorry for the distrub, I am new to SQL veritas cluster and have a question on applying the SQL patch in veritas cluster. My understanding is, we could use following way to apply the patch, is it correct? Many thanks

Environment:

VCS: 7.4.1

SQL: SQL 2017 + CU15 with Active/Passive configuration

OS: Windows 2016 

a. Apply the SQL SP + CU in passive node by using "Passive" parameter from commandline

b. Failover the cluster from Primary node to Passive node

c. Apply the SQL SP + CU in primary node by using "Passive" parameter from commandline

  • before applying the patch on a cluster node, you better freeze the service group which controls/monitors SQL.  Once done on one node, unfreeze the service group then move the service group to another node, freeze the service group again, apply the patch then unfreeze the service group.  If possible, once completed patching up SQL on all nodes, do a test SQL service group failover.

    The other way to patch up SQL is to stop VCS (without stopping the resources controlled by VCS, then follow SQL's instructions to apply the patch on all the nodes then restart VCS.

    You may also want to check with Veritas latest SQL agent release info to see if you also need to upgrade VCS SQL agent ( to the latest patch level).

  • before applying the patch on a cluster node, you better freeze the service group which controls/monitors SQL.  Once done on one node, unfreeze the service group then move the service group to another node, freeze the service group again, apply the patch then unfreeze the service group.  If possible, once completed patching up SQL on all nodes, do a test SQL service group failover.

    The other way to patch up SQL is to stop VCS (without stopping the resources controlled by VCS, then follow SQL's instructions to apply the patch on all the nodes then restart VCS.

    You may also want to check with Veritas latest SQL agent release info to see if you also need to upgrade VCS SQL agent ( to the latest patch level).