Solved

SQL 2008 Cluster with Multiple Instances

Posted on 2010-08-18
4
817 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server tables join on parse list 6 34
SQL Error - Query 6 42
Master DB with Masterkey 1 35
While in ##Table - Help 4 19
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…

828 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