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

To install SQL Server 2008 plus SP1 on Win 7 machines, you have the following options:

1) install the deployment (runtime only - no management tools) version with SP1 built in

2) install the pre-SP1 version (with tools), then upgrade to SP1 (either by downloading SP1, or running windows update -- in either case a 262 MB download, because SP1 is for all editions of SQL server, not just the express edition)

Discussed in this article:

"Microsoft Update experience far superior to having to run through the installer (again) and recomend using this approach rather than downloading and running the SP manually."

...except that is 262 MB a pop.

3) I then found a SP1 download here:

Does SQL Server Express 2008 R2 eliminate the need for this process?

share|improve this question

SQL 2008 R2 is a completely new release so in that sense yes, it does. R2 is not a service pack to SQL 2008 so be aware that you'll be doing a version upgrade if you do have SQL 2008 installed anywhere already.

share|improve this answer
that answers my question, thanks! – d3vid Sep 13 '10 at 12:18

Your Answer


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