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

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