Solved

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

Posted on 2014-12-22
4
79 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
[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
  • 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 49

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

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 2012 r2 - Make Temp Table Query Faster 5 58
This query failed in sql 2014 5 38
Help Required 3 117
Checking for column changes SQL 2014 4 17
     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 …
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

740 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