Is there a way to patch a clustered SQL Server 2005 instance running on two physical hosts without any downtime (or just the downtime during a cluster failover)?
I'm asking this because my DBA claims the clustered instance cannot be available (on either host) during SQL Server patching, which will take about 20-30 minutes. However, I thought that was the whole point of clustering -- one of the cluster instances will be active while the other is down for some reason (hardware, network, and even patching?).
Any guidance is much appreciated.