Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Performing restore of a 7.0 .bak file to 2005 Expand / Collapse
Posted Tuesday, December 16, 2008 10:05 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, January 13, 2015 5:03 AM
Points: 51, Visits: 205
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!
Post #620580
Posted Tuesday, December 16, 2008 10:31 AM



Group: Administrators
Last Login: Yesterday @ 6:10 PM
Points: 34,254, Visits: 18,432
says here you can do the restore:

Not sure what incomplete means. This?

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #620611
Posted Tuesday, December 16, 2008 10:31 AM



Group: General Forum Members
Last Login: Wednesday, October 19, 2016 1:43 PM
Points: 2,038, Visits: 6,199
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
Post #620612
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse