Error 'The media set has 2 media families but only 1 are provided. All members must be provided' while restoring database in SQL Server

firoz1986 says:

Hi sir,

I have a database i took backup of this databse(.bak) file from my office laptop and now i want to restore it in my home's laptop  but it is showing below error. can i fix it.

 

 Hi, I fixed this problem actualy i just selected full instead of simple in recovery model window. now the problem has gone. thanks.

 

 

Hi firoz1986,

Solution is to take another backup or find the second file. What that's saying is that when the backup was taken it was striped over two files, so each file has half of the backup. This is sometimes done by accident when backing up with the SSMS gui. If there are two files listed in the destination text box, the backup will be striped across the two and you'll need both for the restore.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/abf50e00-c9b0-4809-9e61-43ed8a53e968/the-media-set-has-2-media-families-but-only-1-are-provided?forum=sqltools