No no Lucas Peñaloza, please tell your colleague to STOP. He is suggesting a destructive and unnecessary step that will cause you massive operational pain. You absolutely do NOT need to remove a node from the Availability Group (AG) to install a Cumulative Update (CU) or update Reporting Services. In fact, doing so would be a huge mistake for the exact same reasons we discussed regarding the OS upgrade:
- Destruction: Removing the node breaks the replication link.
- Re-seeding: Adding it back later would force you to copy the entire database again (Full Backup + Restore), which could take hours or days depending on your database size.
The Correct Procedure: "Rolling Patching": Microsoft designed SQL Server Availability Groups specifically to handle updates without breaking the topology. The process for CUs is identical to the OS upgrade we just planned:
On the Secondary Node (PWGIRSQL2):
Run the SQL Server Cumulative Update installer.
The installer will stop the SQL Services, apply the binaries, and restart the services.
The AG will briefly show "Not Synchronizing" while the service is down, and then automatically return to "Synchronized" once the service is back up.
Zero configuration changes are required.
Reporting Services (SSRS): The same logic applies. You simply run the update. It will restart the Reporting Services service, but it has no impact on the Availability Group configuration.
So, again, do not let your colleague remove the node. It turns a 30-minute patch job into a 10-hour data restoration nightmare. Proceed with the update while the node remains a member of the cluster and the AG.
VP