Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
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
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 7 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
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this article I will describe the Backup & Restore 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.
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.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 15 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
626 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.