question

SaiVijaya avatar image
SaiVijaya asked

How to reboot of four node SQL failover cluster after applying windows patches

Hi Team,


We have 4 node SQL failover cluster-2017. 2 servers in Datacenter1 and 2 servers in Datacenter2.

one primary node and 3 secondary nodes.


Please suggest best method to restart the cluster after windows security patches update.


Thanks in advance!

sqlteam
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

Node by node, 4,3,2,1

Patch reboot DR data centre first.
Wait for them to be back online.

Patch secondary in primary data centre

Wait for it to be online

Failover

Patch the last machine

Wait for it to be online

Failback over if you wish

2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SaiVijaya avatar image SaiVijaya commented ·

ok, Is there any way without failover always on to restart cluster.
Please suggest.

Thanks!

0 Likes 0 ·
anthony.green avatar image anthony.green commented ·

No, you need to reboot after patching so you need to failover.

If patching SQL , it stops the services also so you again need to failover.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.