Post reply

SQL Server 2005 restore problem

  • September 27, 2008 at 7:36 am

    #198658

    hello any body help me i am using restore the anothersystem database it shows bellow error .please help me who know this solution.

    Error

    System.Sql.SqlClient.SqlServer:The media set has two media families but only 1 are provided .All members must be provided(microsoft.sqlserver.Express.Smo)

    Thanks..

    giri

    Thanks
    Dastagiri.D

  • September 27, 2008 at 8:46 am

    #878082

    That means that the backup was striped across two backup files when it was created, and you only have one of those files. Most commonly this happens because when the backup is made there are two files listed in management studio's backup database dialog. People assume because 1 is highlighted it means the backup's going there. It's not, it's being striped across the two backup files.

    To restore, you need the other backup file. If you don't know where it it, or if it's been deleted, then there is no way you are going to restore. You only have half of the database there.

    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

  • September 28, 2008 at 7:43 am

    #878161

    Go search for another file, who knows what name, but a .bak file with the same timestamp as this one.

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

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