Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
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!
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!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
3
7 Comments
The software does not detect a valid backup, you could mount that backup in an Enterprise edition and export data in a different way, like sql files, then inject them in your Express edition.. if this fails it will show wich operation is invalid on the reduced version
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
Active 6 days ago
Based on this
[My backup is fine and restorable (tried restoring to a SQL 2005 enterprise version on a different machine)]
I guess that it could be a service pack issue.
Any Sql Server should be able to restore a database backed up from the same level and service packs (2005-2005, 2008-2008) regardless of edition.
Can you check and compare service pack levels?
[My backup is fine and restorable (tried restoring to a SQL 2005 enterprise version on a different machine)]
I guess that it could be a service pack issue.
Any Sql Server should be able to restore a database backed up from the same level and service packs (2005-2005, 2008-2008) regardless of edition.
Can you check and compare service pack levels?
Active 4 days ago
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?
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I am showing a way to read/import the excel data in table using SQL server 2005...
Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name".
Now to import this Excel data into the table, we will use…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses
Course of the Month7 days, 13 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.