SQL Server 2008 R2 Service Pack 2

I have a SQL Server 2008 R2 server that needs to be upgraded to SP2 on one of the databases instances.

I can see when running the 2008 R2 SP2 install program that I can select the database instance to update. As I only want to upgrade one of the instances (there are three on there in total), can I do this without any issues as I notice that the 'Shared' components *have* to be updated.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


Yes you can select only one instance but better you upgrade all of the three and shared components will update if both version is same.

Also check which instance you need to update because you wanted to select only one instance on which your database reside.

Also MS recommend to perform backup of your system databases and user databases when you upgrade sql server instances.
HypervizorAuthor Commented:

We don't want to disrupt the other instances, so if we can just upgrade the one instance, that would be better for us at the moment.

Is there any issues with upgrading the shared components, e.g. will that disrupt the other instances?

You can upgrade just one instance with shared component there will be no issue.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.