SQL Server won't restore - versioning issue?

damianshaw

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

damianshaw

mannnnnn - anyone??  

JBI

You simply can't downgrade a database through a restore! This isn't a SQL Backup issue.

Dan B

Hi damianshaw,

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.