Click here to Skip to main content
11,813,974 members (42,191 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: C# VB ASP.NET SQL-Server database , +
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
Edited 9-Oct-12 21: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 Abhinav S 265
1 Maciej Los 203
2 Palash Mondal_ 190
3 Sergey Alexandrovich Kryukov 179
0 OriginalGriff 3,877
1 KrunalRohit 2,526
2 Maciej Los 2,245
3 CPallini 2,240
4 ppolymorphe 1,750

Advertise | Privacy | Mobile
Web03 | 2.8.151002.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