How to apply Windows patches or service pack cumulative or Hotfix in SQL Server in two node cluster environments?

Scenario:

Step by Step I have to apply Windows patches or service pack cumulative or Hotfix in SQL Server in two node cluster environments?

Solution: - The below are the Easy steps to complete this activity-

1.       Take the latest backup of database for repository purpose or DR.  

2.       Login to server both server (Node_1 and Node_2).

3.       Open cluster manager( Run àcluadmin NODE_1 ) on Node_1 and go to the Roles à move the all resources (SQL Services, MSDTC server etc.) on node (i.e. Node_2).

Note-All Disk will move when you will move services.

4.       To do this click on services/resources à More à Select Node as Node_2 and wait till the service status is Online Owner node status changed from Node_1 to Node_2.

5.       Do the same to move MSDTC service.

6.       Now, none of the services are running on Node_1 so that we can run downloaded patch or service pack, cumulative or Hotfix on Node_1.

7.       After Appling Service pack move back all the services on Node_1 and Once the services are online on Node_1

8.       Apply patch or service pack, cumulative or Hotfix on the Node_2.

9.       After applying Service Pack, verify all cluster services and disk should be online.

10.    Also, click on Node and verify both Nodes should be in Online state.

11.    Now click on Cluster name à Click on Validate cluster (Right side) and run the all recommended test and make sure no warning or error should be come. If it is there then need to fix it.

Note: - Windows server 2012- we have option Windows – Cluster Updating feature using this we can identify which Nodes are ready for update, which patches is required, Analyze Nodes before applying patches, also it can download the require patch and using schedule option it automatically apply patches.