Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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 do know that it would be much better if I try it first.
But the problem is that its my client's dedicated server with many websites running on it.
So, I cannot actually test that there.

The server is Windows Server 2008. My queries are

  1. Does SQL 2008 R2 express and SQL 2008 reside on the same machine?
  2. Does installing SQL 2008 R2 need OS upgrade to Windows Server 2008 R2?
  3. What will the side effects of this be?
share|improve this question
up vote 2 down vote accepted

Yes, absolutely! SQL Server 2005 and later happily instance stacks together, and to be fair SQL Server 2000 does it quite well too.

Windows 2008 will be fine - I haven't personally tried that combination. Having said all that, I'd recommend always doing it on a scratch box first!

Two or more instances on the same OS will require their max memory setting to be configured appropriately, and both instances monitored for performance.

SQL Server 2008 requirements:

SQL Server 2008 R2 requirements:

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.