Solved
Restoring backup from an enterprise edition to express edition
Posted on 2010-08-26
Is there really a known issue when restoring a backup file from an enterprise edition of SQL 2005 to express edition?
I'm getting this error:
Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'E:\MyBackup.bak'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I tried running this too:
RESTORE FILELISTONLY
FROM DISK = 'E:\MyBackup.bak'
same error:
The media family on device 'E:\MyBackup.bakk' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
My backup is fine and restorable (tried restoring to a SQL 2005 enterprise version on a different machine)
Any insights? Thanks!