Performing restore of a 7.0 .bak file to 2005

  • I have a database backup I'm trying to restore to a newly created database on a sql 2005 server. I'm receiving the "The media family on device 'C:\etc\etc' is incorrectly formed. Sql server cannot process this media family.

    Looking at the backup set it says '*** INCOMPLETE ***' as the name.

    I'm suspecting this is a backup file from a sql server v7.0, and I've tried setting compatibility mode to 70 prior to performing the restore but I get the same thing.

    It IS possible to restore a 7.0 backup to a db on a 2005 instance right?

    Does the *** INCOMPLETE *** mean that the backup was performed using more than one file maybe and I have only one?

    Any programs out there that can verify the file for me, or read a few pages and tell me what type of backup it is or something?

    Thanks in advance!

  • says here you can do the restore:

    http://msdn.microsoft.com/en-us/library/ms187495(SQL.90).aspx

    Not sure what incomplete means. This?

    http://www.eggheadcafe.com/software/aspnet/30578212/restore-problem-the-m.aspx

  • I'm not sure about the media family error, but you can restore SQL 7.0 to SQL 2005.



    Shamless self promotion - read my blog http://sirsql.net

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply