Behaviour of SQL Server after Windows Security patching
Hi Team, Can any one tell what affect can hapen to SQL Active Active cluster After Windows Security patching. Windows team are going to update the security patch on our Active Active cluster. Do i need to bring the node offline before the patching. or i can stop the service of SQL service. Do Stoping the Sql server will not affect the fail over . Thanks Basit khan
You mention Active/Active cluster, by this I presume that you are running two SQL instances on a two node cluster. If this is the case here are the steps I recommend for patching Windows: 1. Failover InstanceA to ServerB (this leaves InstanceA & InstanceB running on ServerB) 2. In Failover Cluster Manager pause ServerA 3. Apply Windows Patches to ServerA and reboot 4. Unpause ServerA 5. Failover InstanceA & InstanceB to ServerA 6. Test to ensure that you have no problems/issues 7. Pause ServerB 8. Patch ServerB and reboot 9. Unpause ServerB 10. Failover InstanceB to ServerB 11. Done
Personally, I'd take the node offline for patching like this. Also, I'd make sure I had a good backup in place before hand (good = tested recovery). Depending on how you stop SQL Server, it can cause a failover, so be sure you use the Cluster Manager software to stop the service if that's what you're going to do.