Issue
Restore of SQL Database fails with error message - "The media set has 2 media families but only 1 are provided. All members must be provided.".
Environment
Continuum
Microsoft SQL
Cause
When the Database was backed up it was setup as a "striped" backup across a number of files. See MSDN article below that explains this in detail.
Resolution
Either provide all of the files in the backup set or perform another backup of the database making sure to remove all existing files and selecting a new one.