I did a full DB backup that I am trying now to restore via the SQL Server Management Studio.
I select "Restore" and then "From Device" and point to the bak file that I want to restore from.
I then go into the Options page and check "Overwrite the existing database".
Below that, shows the Restore the database files as
When I then click OK I get the following error. The Media Set has 3 Media Families but only 1 are provided. All members must be provided.
Any ideas as to what I did to do to be able to complete this restore?
refer this it has the solution
It seems your backup is splited into 3 files but at time of restore you are providing only 1 backup file.
Check the no. of files in which backup is splited by below command & use all file to restore the database.
FROM DISK = '<backup file location>'
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!
Seems like backup exist in multiple files and somehow you missed one of them
try to restore header only and see if you are getting header details or not.
hi RahulKapoor & RhitGarg
look at the date of the first and last posting - February 2007 / July 2007.
I don't believe that your answers would be helpfully to anymore to the original poster
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.