we have an old server that we want to dedicate fully as a public webserver (hosting a few DotNetNuke sites), and for this purpose we would like to install SQL Server Express (probably 2008) on the server and thus have both the Database server and the Web Server on the machine.

But: The databases for the webserver are hosted on a SQL Server 2005 Standard today.

So the question is: Is it possible to move a database from a Standard Server to an Express Server?


Answer: yes. It is possible. It is actually trivially simple (detach database, attach at new server instance).

Btw., take 2008 R2 express, not 2008 express. 2008 is outdated already.

  • Thanks! Will install 2008 R2 Express and try it out, and give you the answer as soon as it is confirmed. :)
    – Bjørn
    Nov 15 '10 at 8:20
  • Worked like a charm!
    – Bjørn
    Jan 4 '11 at 7:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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