Solved

SQL 2008 Cluster with Multiple Instances

Posted on 2010-08-18
4
791 Views
Last Modified: 2013-11-05
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
Comment
Question by:stebennettsjb
  • 3
4 Comments
 
LVL 3

Expert Comment

by:robertodeacruz
ID: 33469977
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
 

Author Comment

by:stebennettsjb
ID: 33498774
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
 
LVL 3

Expert Comment

by:robertodeacruz
ID: 33500143
You're right. I just checked. I'm just updated patches in default instance. The other instances are not updated.
0
 
LVL 3

Accepted Solution

by:
robertodeacruz earned 500 total points
ID: 33500221
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

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now