Post reply

DB Restore error

  • December 27, 2013 at 3:13 am

    #280835

    I am getting error during DB Restore in SQL Server Management Studio.

    I have a .bak file.

    when I try to upload this back up file by browse

    System.Data.SQLClient.SQLError the media set has 2 media families but only 1 has been provided . All memebers must be provided.

    How do I solve this issue ?

  • December 27, 2013 at 5:13 am

    #1676054

    You find the other half of the backup.

    That error means that the backup was striped across two files, either because two files were specified in the BACKUP DATABASE statement or because two files were listed in the destination in the backup dialog. The backup was striped across the two files with half of the backup in each. To restore you need both files.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply