Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 859
  • Last Modified:

SQL 2008 Cluster with Multiple Instances

Hi,

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

S
0
stebennettsjb
Asked:
stebennettsjb
  • 3
1 Solution
 
robertodeacruzCommented:
I work with SQL 2005, but believe that the 2008 works the same way.

If you have a cluster of two nodes and three SQL instances, you won't apply the SPs and patches six times. You will need to apply twice, because patches are applied by node and not per instance.

In relation to WSUS, it works normally with the SQL cluster, because it will not update the cluster, it will update the nodes.
0
 
stebennettsjbAuthor Commented:
Hi robert,

If this is true, then isnt a major part of what instances are ruined? The idea of having instances needing different service packs would be impossible without manual patching!?

I read in forum that WSUS only updates the default instance of the node. But as it was only referece i could find in about 2 hours of searching google i wasnt sure.

Thanks for the info.
 
S
 
0
 
robertodeacruzCommented:
You're right. I just checked. I'm just updated patches in default instance. The other instances are not updated.
0
 
robertodeacruzCommented:
Certainly, the manual application of service packs you can mark the checkbox "Apply selection to all instances" to update all instances at once.

Now by WSUS I still need more research.

Regarding individual patches released before a service pack, also need more research to give a correct answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now