Post reply

Error->Restore Master Database

  • December 26, 2008 at 3:59 am

    #126220

    Hi All,

    Am getting the below error while trying to restore the backed up master database (in single user mode only):

    Master database Restore:The media set has 2 media families but only 1 are provided. ALL members must be provided.

    Note: I cannot backup the master database again.

    I would appreciate any kind of help for the above error.

    Many thanks in advance!

  • December 26, 2008 at 8:29 am

    #917800

    You performed a striped backup. The backup of master went to two files, not one and you are only specifying one file.

    Unless you find the other file, you cannot restore.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • December 26, 2008 at 8:43 am

    #917809

    yes that is right you performed a striped backup, you can't restore until you find another file.

    Rajesh Kasturi

  • December 27, 2008 at 3:00 am

    #917997

    But I think I had taken the backup in a single destination only.

    Is it possible to get the error in the above case?

  • December 27, 2008 at 3:10 am

    #918000

    jananik (12/27/2008)

    But I think I had taken the backup in a single destination only.

    Did you backup using the management studio gui? If there were two files listed in the destination box, the backup was striped across the two, even if one was highlighted.

    Is it possible to get the error in the above case?

    No. The error means that the backup was stripped and you only have some of the 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

  • December 28, 2008 at 12:18 am

    #918117

    Thank you... I shall check again for more back files specified on that data...

    But to my knowledge i would have specified one location in the destination list.

    Anyway thanks all....

  • December 28, 2008 at 12:27 am

    #918118

    You are welcome

    Rajesh Kasturi

  • December 28, 2008 at 7:16 am

    #918135

    Did you solve the problem?



    My blog

  • December 29, 2008 at 9:17 am

    #918425

    try running the query if u have still doubt

    restore verifyonly from disk=' ' which will provide the details backup file consistancy

Viewing 9 posts - 1 through 8 (of 8 total)

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