How can we help you today? How can we help you today?

SQL Server won't restore - versioning issue?

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
Damian
0

Comments

3 comments

Sort by
  • damianshaw
    mannnnnn - anyone??
    damianshaw
    0
  • JBI
    You simply can't downgrade a database through a restore! This isn't a SQL Backup issue.
    JBI
    0
  • 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.
    Dan B
    0

Add comment

Please sign in to leave a comment.