SQL Server won't restore - versioning issue?
damianshaw
Posts: 2 New member
in SQL Backup
Hi there - I've been an SQLBackup user for years and never had an issue (thank you!) but today I tried to copy a database from a production environment to a development environment and the restore failed with a
"RESTORE FILELIST is terminating abnormally"
"the media family on device" .... "is incorrectly formed"
this update is going from an SQL Server 2008 environment to 2005 - is that my issue (forum searching would suggest it is)? I don't think I've attempted to do a restore from this production setup to the dev. setup before (not sure though)....
thanks for your help!
Damian
"RESTORE FILELIST is terminating abnormally"
"the media family on device" .... "is incorrectly formed"
this update is going from an SQL Server 2008 environment to 2005 - is that my issue (forum searching would suggest it is)? I don't think I've attempted to do a restore from this production setup to the dev. setup before (not sure though)....
thanks for your help!
Damian
Tagged:
Answers
As JBI points out you can't downgrade a database via a backup and this is a limitation within SQL Server so a native backup would behave in the same way.
You can use a combination of Compare and Data Compare to downgrade your database though if this is something you need to do regularly.
Dan Bainbridge
Product Support Engineer | Redgate Software