Restoring backup from an enterprise edition to express edition
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!
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!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What happens when trying to inject the SQL?
If you see, something like "Error executing SQL at line XXX" or something its an indication that the database design is not compatible with the reduced function set of the Express edition, in that case you will need to de-desing the database and build up a conversion tool
If you see, something like "Error executing SQL at line XXX" or something its an indication that the database design is not compatible with the reduced function set of the Express edition, in that case you will need to de-desing the database and build up a conversion tool
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it's the same error. what I did for testing was create a database with one simple table in enterprise edition, insert one row, backup the DB and restore it to an express edition. it really will not work....
Cyberkiwi: i agree, that's why i suggested a plain text sql file transmission, the language should be compatible as the standard doesnt change from SP to SP, and should be backwards compatible if restoring into a 2008.
Faiga: in your last post you mentioned a DB backup-restore process, have you tested the sql method?
Faiga: in your last post you mentioned a DB backup-restore process, have you tested the sql method?
ASKER
My bad, the other server was a SQL 2008 R2. ANd i'm trying to restore it to a lower version (SQL 2005).
Thanks cyberkiwi and emileneth!
Thanks cyberkiwi and emileneth!
ASKER