Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm moving from a shared hosting company to a dedicated server. The hosting provider used SQL Server 2008 (not sure if it was Professional or Standard). I've installed SQL Server 2008 Express on the dedicated server. The hosting company has provided me with backups of our databases. I'm going to restore these backups into SQL Server 2008 Express.

Is this possible? Can I restore a SQL Server 2008 database into SQL Server 2008 Express?

share|improve this question
add comment

2 Answers 2

up vote 2 down vote accepted

Most likely, yes. Have a look here for a comparison of the SQL Server 2008 editions:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

share|improve this answer
    
I tried it out last night and I was able to restore without any problems. –  ElephantMoss Feb 21 '10 at 13:24
add comment

You can restore, as long as the source database is not using any of the Enterprise/Standard Only features [like Compression]

share|improve this answer
add comment

Your Answer

 
discard

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.