SHOWING ERROR WHILE BACK UP THE DATABASE IN SQL SERVER

Linda Perla

Total Post:13

Points:93
Posted by  Linda Perla
 630  View(s)
Ratings:
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)
  1. Mayank Tripathi

    Post:397

    Points:3117
    Re: Showing error while back up the database in sql server

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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!