Solved

SQL 2008 Cluster with Multiple Instances

Posted on 2010-08-18
4
828 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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 Results to Excel File 18 88
database level memory cache..? 8 44
SQL DATEADD 10 87
SQL Server how to use a VARIABLE to link tables in a SQL Script? 3 36
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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 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