SQL 2008 Cluster with Multiple Instances
Posted on 2010-08-18
Just want to check what im understanding is right.
We want to install a sql 2008 on 2 nodes (windows server 2008 OS). We also run multiple instances on the cluster all running 2008 due to some applications not lockign down the SA account and others needing more specific builds.
From what i understand, for each instance on the cluster we will need to do all patchs twice (Once on each node of the cluster)
Am i correct so far? Does anyone have any experience of SQL 2008 Clustering with instances care to share any helpful hints and tips with me!? :)
Main things im worried about is maintance of the servers, we currently use SCCM and WSUS for monitoring and rolling out updates.
How does WSUS work with multiple instances ???
How does SCCM 2007 work with multiple instances ???
Thanks for any advice