SQL Server Error : system.data.sqlclient.sqlerror the media set has 2 media families but only 1 are provided
This happens because the data is split into two. I think this happens when u put more then one destination in backup to disk when u backup the database
Just take a backup again. Specify only one location. when mentioning the file name.
Then restore u should be good to go.