Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Location
    MG - Brasil
    Posts
    2

    Thumbs down Unanswered: Restore Database

    When I try to restore my database receive the message:

    "The media set for database 'MyDB' has 2 family members, but only 1 are provided. All members must be provided."

    I don't find the other dump device.

    Do I can restore anyway??

    thanks,

    Ericson.

  2. #2
    Join Date
    Jan 2003
    Location
    Pittsburgh, PA
    Posts
    86

    Question Similar problem

    I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?

    Any ideas?

  3. #3
    Join Date
    Sep 2002
    Location
    MG - Brasil
    Posts
    2

    Red face Re: Similar problem

    Originally posted by acg_ray
    I am having a similar problem with a backup of a database that has been successfully running the past two months. Suddenly this weekend, the same error message started appearing for me?

    Any ideas?
    I have no succes to restore my database.
    I has create the database again e loses the data.

  4. #4
    Join Date
    Feb 2004
    Posts
    1

    Thumbs up Same problem - good guess though

    One of my customers reported the same problem that you guys were having. I found in his case that he had spanned his backup across multiple files when he made it.

    So, in the Database Backup Destination box, he had multiple entries before backing up. Then when he went to restore the database to another machine, he was unaware that he should have had multiple files. This restore file was coded to tell Sql Server that it was only one part of the backup.

    In his case, I had him go back to the server and create only one backup file.

  5. #5
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Restore Database

    Are you using tape backup? It may be that your database backup run across two tapes and it's looking for another backup media.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •