Tuesday 8 December 2009

Restore SQL Server 2005 DB on 2005 Express

Question:
We have a SQL server 2005 database in a shared production environment.
We do a backup of this database and want to restore it in a development environment having only a SQL-2005 Express Edition.
You cannot restore the prod database using the Management Studio Express.
What to do??