We have one server with multiple SQL Server 2008 R2 instances installed. To support an application we need to upgrade one instance to SP2. Can we only apply the service pack to the specific instance on the server, or would it have to be applied to all of the instances on the server?
Sql-server – Update one instance of Sql Server 2008 R2 Standard to SP2
sql serversql-server-2008-r2
Related Question
- Sql-server – How to fix SQL Server instances with different builds on same server
- Sql-server – How to pull a list of applied service packs and cumulative updates from SQL Server 2008 R2
- SQL Server – Upgrading a Single SQL Server 2008 Failover Cluster Instance to SQL Server 2012
- Sql-server – SQL Server 2008 R2 on production — is it worth to upgrade to SP1/SP2
- SQL Server – Differentiate SQL Server Express from Server Installation
Best Answer
Yes, you can choose which instance(s) you wish to apply the service pack. They'll all be checked by default; as will the client tools / shared features (there is only one "instance" of those):
You can re-run the installer later to update any that you didn't update this time; the ones that are already at SP2 will not be selectable.
On this VM, I have 2008 R2 RTM (no patches whatsoever) and 2008 R2 with Service Pack 2 and CU9, installed and running side by side with no issues:
Now, why you want to have a mix of patched and unpatched instances on a single server might be a different question...