You get this error while restoring the database backup file in SQL Server 2005. This is because when you took the backup your backup file is divided in more than one part and at the time of restoring the database you have not added all the parts.
Lets do this practically so that you can have better idea. Take the backup of any database you have. To take the backup right click on database and select the task and click on backup,
Fig – (1) How to take backup
Once you click on Backup you have to select the location for .back file on database. If there are two paths in path selection box as shown in image below, the backup file is generated in two parts and saved at two different locations.
Fig – (2) Two paths in backup file path selection.
So in this case, we have two backup files generated for selected database. Now at the time of restoring if you are assigning only one file and try to restore the database, you will get “The media set has 2 media families but only 1 are provided.” error.
To solve this issue you have to add all the files (in our case two files) in file selection box,
Fig – (3) Restoring database
Once you select all the backup files and click on restore, the database will restore successfully.
For more detail check here.
Happy Programming !!
be chirga……….
topa aama kai samjay evu to lakh
i have same problem here
Rahul, you are the man. I tried to restore this for an hour and was unsuccessful but your solution took me 10 minutes and everything is restored
Thank you, Thank you, Thank you, Thank you, Thank you and Thank you
Best wishes
I did a long fight with it. I came across this solution on time and worked smooth. Thanks.
Thanks for information. I served much.
Really thanks. Good study realized me my mistake during taking backup of database.
Regards,
Rajeev
Thanks guys. This really helped me out.
Thanks for posting this, it really helped me.
Nice photo; what city is that in the background?
Why does everybody in the photo have bandaged fingers?
I have been trying to restore a file which has 2 sets as the example given above but the steps shown here are not much help to me, please assist:-(
Worked for me.
THANKS!!!!
Great Tutorial!
It works fine!
Thanks a lot!
Thank you so much for the post – saved me a load of time and stress
Thank you for posting this!! Helped me greatly.
Thanks ,Great tutorial helped me in resolving the issue.
Thanks good tutorial help me to resolve the issue
thank you but if i need only one, shall i remove the second and and only keep the 1st backup and restore it?
very simple and good solution provided thanks for the post
I have forgotten the another part of media , is there any possibility to restore the data.
thank you this page is very useful for me.
Hello every one,
Can we have two media sets in one media file.
Ex: Media File(D:\Backup\ TestMediafile.BAK)
Media set(FirstMediaSet)
Can we have SecondMediaset in same D:\Backup\ TestMediafile.BAK
Help me on this.
Thanks & Regards
Sudharshan
ksreddy.ar@gmail.com