Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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: Monday, August 11, 2014 1:59 AM
Points: 50, Visits: 188
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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:53 PM
Points: 33,204, Visits: 15,353
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







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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, July 11, 2014 10:29 PM
Points: 2,007, Visits: 6,077
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
Post #620612
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse