I'm getting an error whenever I restore a testing database on SQL Server 2005 that was backed up from SQL Server 2008 R2. It seems that I cannot restore from a higher version of sql onto lower version, how can I solve this?
The media family on device is incorrectly formed. SQL server cannot process this media family. RESTORE HEADERONLY is terminating abnormally.
I already tested to restore the same file in its own server (SQL Server 2008 R2) and it works, so it's not corrupted.
I cannot install the updated version of SQL into my older server, so how can I use my older SQL Server 2005 as a dev server but with the updated life data from a different instance?
Best Answer
You can't restore a 2008 backup on SQL Server 2005. Simply not possible.
You'll need to either:
(a) Restore it on 2008, then use Import/Export wizard, Generate Scripts Wizard, Copy Database Wizard, SSIS, 3rd party tools like SQL Compare, etc. to move the structure and data to the 2005 instance, or
(b) Upgrade. Developer Edition is $50 or so.