Home > DeveloperSection > Forums > Showing error while back up the database in sql server
Linda Perla
Linda Perla

Total Post:13

Points:93
Posted on    June-15-2015 1:14 AM

 MSSQL Server MSSQL Server 
Ratings:


 1 Reply(s)
 345  View(s)
Rate this:
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)


Mayank Tripathi
Mayank Tripathi

Total Post:397

Points:3117
Posted on    June-15-2015 8:17 AM

Anyway, 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'.


Don't want to miss updates? Please click the below button!

Follow MindStick