With CLUE as (Select * from Random_Thought ORDER BY Common_Sense DESC)

SQL Server thoughts, observations, and comments
posts - 52, comments - 79, trackbacks - 0

December 2009 Blog Posts

SQL 2005 Patching

I just got this question from a blog reader: We have a SQL 2005 cluster active/passive.   Under my understanding, it would be neccesary to apply patches into a Testing environment, if working fine, proceed to the production environment... but, is it recommended to patch both nodes the same day?  or instead it would be better to patch Node1 (active) and wait some days before patching Node2 (passive)? I would like to know your opinion on this matter ! Thanks a lot for your support. The answer is you always must patch all nodes at once using SQL 2005.  Rolling upgrades/patches was introduced in SQL...

posted @ Thursday, December 03, 2009 11:01 AM | Feedback (1) | Filed Under [ High Availability ]

Powered by:
Powered By Subtext Powered By ASP.NET