September 25, 2013 at 8:59 pm
I have 3 SQL 2008 R2 SP1 instances on a server. And i want to upgrade only 1 instance to SP2. I use an automated installation code in a batch file as below which cannot be changed now.
R2SP2setup.exe /IAcceptSLServerLicenseTerms="TRUE" /quiet /allinstances
For the other 2 instances which i don't want to patch with SP2, if i keep their SQL services in stopped and disabled state, will it work and upgrade only the one i require. Please let me know if there is any other option. I cannot change the /allinstances parameter in the above code as it is already in Production.
September 26, 2013 at 6:42 am
You can't upgrade an instance separately from other instances. It's all or nothing.. Or a side by side install.
I would recommend installing a brand new R2 instance in a different directory (so it doesn't muck up your current install), then adding any jobs, permissions, etc. that need to be on the new instance. Move the databases last and upgrade them as you add them to the new instance.
September 26, 2013 at 6:50 am
you can upgrade just one instance.
In this case I would recommend doing the upgrade manually.
---------------------------------------------------------------------
September 26, 2013 at 7:01 am
george sibbald (9/26/2013)
you can upgrade just one instance.
Really?
I don't remember seeing that available in my install files. Now I'm going to have to go try it...
Hrm. Something else to learn about SQL. @=)
September 26, 2013 at 7:06 am
Really 🙂
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply