We help IT Professionals succeed at work.

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

130 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?
Comment
Watch Question

IvanSystem Engineer
CERTIFIED EXPERT

Commented:
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,
waltforbesSenior IT Specialist

Author

Commented:
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
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
waltforbesSenior IT Specialist

Author

Commented:
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.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.