up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
75% accept rate
feedback

2 Answers

up vote 3 down vote accepted

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.

link|improve this answer
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
feedback
up vote -1 down vote

We are trying to do something very similar... SQL Server 2000 Std to SQL Server 2008R2 Express. I tried an in-place upgrade, but I'm being told it's an unsupported upgrade path.

Is there a way to migrate from std 2k to express 08R2?

link|improve this answer
1  
Hello and welcome to Server Fault. Where you posted this is a place for answers and not more questions. If this particular topic does not answer your question, do a search on serverfault to see if it's already been asked. If it hasn't, then by all means, please post a new question. – GregD Jan 3 '11 at 22:19
Oh, and you may want to have a look at the FAQs: serverfault.com/faq – GregD Jan 3 '11 at 22:20
feedback

Your Answer

 
or
required, but never shown
discard

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