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 have been told I need to install Sql Server 2008 r2 on my development PC, do I just install Sql Server 2008 and then let windows update install r2 – e.g. is it like any other service pack?

share|improve this question
up vote 4 down vote accepted

No, SQL 2008 R2 is a completely separate release from 2008, it is not a hotfix or service pack. You must install clean or do an in-place upgrade.

share|improve this answer
thanks, I will get it down loaded from our MSDN subscription – Ian Ringrose Feb 18 '11 at 9:22

..or you can do a side by side install, but please be aware some of the shared components will be upgraded.

share|improve this answer
+1 Good point, that – squillman Feb 17 '11 at 21:38

As squillman and retracement said it completely separate but it's also inexpensive. Prices fluctuate on Amazon but I've seen R2 for as low as 42 bucks and you can put it on multiple machines, as long as they aren't production machines.

share|improve this answer
To clarify this, $42 would be for SQL Developer Edition which is expressly targeted toward single devloper, no production installations. It may not (legally) be used in any form production environment or by more than one developer. – squillman Feb 17 '11 at 21:37

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.