Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2002
    Location
    Rochester, Kent, United Kingdom
    Posts
    32
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Restore (SQL 2005)

    Hi Guys
    Getting an error when restoring a database into sql 2005. The original DB was 2005 too...
    "The Media set has 2 media families but only 1 are provided"
    Any ideas?

    Thanks Si

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Restore (SQL 2005)

    It means that you must have striped the backup over two backup files. You must provide both in order to restore the database.

    Try RESTORE LABELONLY. If this returns more than one row, you know that there must be two backup files.

Posting Permissions

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