Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

today I was trying to restore a database with a backup I had made previously on another computer, however I kept getting the following error message:

the media loaded on "filepath" is formatted to support 2 media families, but 1 media families are expected according to the device specification

I didn't look into it at the time, I just figured it was a bad backup and I'd redo it when I got home. So now I'm trying to do another backup, and I'm getting the above error message for that too.

I did backup to a different location at one point, however that no longer exists now. Is there a way i can get passed this error and just do a fresh backup of the database?

any pointers would be much appreciated :)

share|improve this question

2 Answers 2

up vote 2 down vote accepted

It's expecting two seperate files to fulfil the backup set, and you've only supplied one. One was possible the database backup file and the other one maybe a transaction log?

share|improve this answer
    
Hi Mark, thanks for the reply. I actually managed to dig out the other backup file, two .bak files. I'm not sure how that happened but I should be able to restore the database now. thanks :) –  109221793 Feb 9 '11 at 22:24

You need to do the backup to a new file. The existing file is configured so that you split the backup across two backup files. You may as well delete the file if you don't have the other file, as the backups which are contained within the file are useless as half of the backup information is missing.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.