Solved

SQL 2008 Cluster with Multiple Instances

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

     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 …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

832 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