Search This Blog

Monday, February 11, 2013

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)


Error:
System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)


1. When you make the backup, change the Backup Set Name.

2. Remove all of the destinations listed, and add 1 new destination.

3. Do a full backup.

4. Restore this back file .

No comments :