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
Solved

How Do I Upgrade a Single SQL Instance at a time?

Posted on 2014-12-22
4
78 Views
Last Modified: 2014-12-23
Points of My Scenario:
1. I am admin of a Server 2008 R2 domain
2. I administer a 2-node physical SQL Server 2008 R2 SP1 cluster on Windows Server 2008 R2 SP1
3. I plan to implement SCCM 2012 R2 for the enterprise, using the SQL cluster in point #2
4. The SQL Server has several instances - one of which will be used for SCCM 2012 R2
5. A SCCM 2012 R2 pre-requisite is that SQL 2008 is to have SP2 and Cumulative Update 7
QUESTION: How can I (if possible) upgrade a specific instance of SQL to a higher service pack & cumulative patch, without upgrading the other SQL instances on the cluster?
0
Comment
Question by:waltforbes
  • 2
4 Comments
 
LVL 16

Expert Comment

by:Ivan
ID: 40513965
Hi there,

you can upgrade only specific instance of SQL, no need to upgrade all. I have done it on stand-alone SQL, but it can be done on clustered as well (haven't done that one).

Here is a link for clustered one. http://msdn.microsoft.com/en-us/library/ms191295(v=sql.100).aspx

Regards,
0
 

Author Comment

by:waltforbes
ID: 40514013
Hi spriggan13:
1. My SQL cluster nodes are already running SQL Server 2008 R2 with service pack1
2. My Quest: install Service Pack 2 (and Cumulative Update 7) on a specific instance.

Regards,
Walt
0
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40514437
Walt, when you run the SP2 and CU7, there will be a screen when it listed all existing instances in the server/cluster. You just need to uncheck all and only check the instance that you want to be patched.
0
 

Author Closing Comment

by:waltforbes
ID: 40515265
Wonderful, wonderful, wonderful! That's exactly what I needed to know! Many thanks, Vitor Montalvão!
I will create a separate question on how to backup 'system state' for a particular SQL instance - in case roll-back is necessary.
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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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…

839 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