Are different service packs allowed in a multiple SQL instance in 1 server ?

Question

Are different service packs allowed in a multiple SQL instance in 1 server ?

smile_netz

Ten Centuries

Points: 1018
More actions
January 13, 2011 at 9:23 pm

#243657

Are different service packs allowed in a multiple SQL instance in 1 server ?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

As in 2 or 3 standalone (not clustered) instances on a single machine? Yes, they can even be completely different versions.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

WayneS SSC Guru Points: 95460 More actions · Answer 2

However, the core (shared) components would be at the highest SP level.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 3

Shared components are client tools and non-instance aware services. Not all SQL Server services are multi-instance.