Restore database in SQL Server 2005 Express

One of the clients asked if our system would work fine in SQL Server 2005 Express, and I was assigned the task to find out the difference between SQL Server 2005 vs SQL Server 2005 Express

Excited, I installed SQL Server 2005 Express to see for myself (and since its free, why not?) I noticed I couldn’t reattach a database to it (as you can see from the screen shot)

I tried to restore the database using the wizard but encountered errors doing so

The advice I got from the forum was to use command prompts WITH MOVE options. With the example given by Pinal Dave on Restore Database Backup Using SQL Script (T-SQL) , it worked like a charm.

---

Possibly related posts: (automatically generated)

• Errors upgrading SQL Server 2005 to SQL Server 2008
• SQL Server 2000 vs SQL Server 2005 queries
• Backup SQL Server 2000 using SQL Agent
• Install Adventure Works sample database on the SQL Express