Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a server that is running SQL Server 2005 Express.

It currently has 2 instances of SQL Server running.

  • Instance 1 runs some old legacy software that is not supported by me.
  • Instance 2 runs my software.

Is it possible to upgrade instance 2 to SQL Server 2008 R2 Express independently of instance 1, i.e. keeping instance 1 on 2005 while instance 2 is upgraded?

share|improve this question

migrated from Nov 2 '12 at 17:55

This question came from our site for professional and enthusiast programmers.

Yes. Upgrading an instance only applies to that instance and side by side installs of different versions are fine. – Martin Smith Nov 2 '12 at 17:17

Absolutely, when you run setup for SQL Server 2008 Express choose the instance you want to upgrade. By doing so you only upgrade that instance to SQL Server 2008 R2. Other instances will stay on 2005 however any client tools like Management Studio Express will be upgraded to 2008 R2.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.