Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C# ASP.NET SQL-Server VB.NET , +
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 21:10pm
Edited 9-Oct-12 22:15pm
Bernhard Hiller at 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 at 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
0 Zoltán Zörgő 300
1 /\jmot 205
2 Peter Leow 165
3 CHill60 145
4 CPallini 135
0 Sergey Alexandrovich Kryukov 9,373
1 OriginalGriff 6,881
2 Peter Leow 4,577
3 Zoltán Zörgő 4,244
4 CHill60 2,892

Advertise | Privacy | Mobile
Web01 | 2.8.150129.1 | Last Updated 11 Oct 2012
Copyright © CodeProject, 1999-2015
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