I am facing some error while i am trying to back up my database in sql server R2. it is showing the following error:
TITLE: Microsoft SQL Server Management Studio
Restore failed for Server 'Ironhide\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)
Anonymous User
15-Jun-2015Anyway, your backup set was splitted in two files, but you're trying to restore the data from just only one backup file.
One solution is to backup your data in just one file and repeat the restore process. The other one is to provide both backup files and try to restore again the data. In this way, SQL Server won't warn you again with that error.
Refer this thread
Sql server - Restore failed for Server 'servebrname'.