Click here to Skip to main content
13,055,629 members (51,765 online)
Rate this:
Please Sign up or sign in to vote.
Hi guys,

I want to backup Database and restore it again, but after backup and try to restore it error message appear:

SqlError The media set has 2 media families but only 1 are provided

I can not to restore my database again.

I use SQL Server 2005
Posted 9-Oct-12 20:10pm
Updated 9-Oct-12 21:15pm
Bernhard Hiller 10-Oct-12 2:57am
How did you create the backup? How do you try to restore it?
Which version of SQL Server do you use? - Are the versions different for backup/restore?
Do you use SQL Server Management Studio? Which version?
MrProgrammer_78 10-Oct-12 3:16am
I use SQL Server 2005, and not different version,
I Backup and Restore like this:
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

when u created backup it may be possible that in the list displayed in bottom you had two different backup files added and now you are restoring with only one file. please check. re create backup after deleting all existing backups. hope it solves your problem. happy to help.........
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

chose mdf file location
and log file location

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 11 Oct 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100