Restoring Databases between SQL2005 Express and Developer Editions

Hi,

Are there any issues between porting databases fom SQL2005 express to SQL2005 Developer?

I'm trying to move Adventure works between the two on my Laptop. Both instances were installed identically and in the same directory paths except express is in MSSQL.1 and Developer in MSSQL.2

If I try to backup from Express to Developer and restore in developer I get an error suggesting that the backup contains more than 1 database image. When I detach\attach from express to developer I get a

Msg 5133, level 16, State 1, Line 1

Directory look up fro the file 'c:\program files ....' failed with operating system error 123 (error not found)

Does anyone have any ideas?

Thanks in Advance

Dave

Yep. The database file locations are stored within the backup media, you will have to change the file location of the datafiles during the configuration of the restore (if you use the GUI to perform the restore) or use the WITH MOVE Option if using the TSQL command for restoring.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
--