SQL Server: The media set has 2 media families but only 1 are provided

When you are restoring a database if you get error like the below one, no need to worry. Just take back up once again as explained.

Backup mediaset is not complete. Files D:\other\TEST. Family count:2. Missing family sequence number:1


Reason:
This error message means that the original backup was done as a striped backup where the backup stream was split into two destination files. Depicted in below screen shot.



Solution:
When attempting to restore, you need to specify all of the same files which were used to take the backup.
(or)
Take a back up again with one path selected and remove all other paths listed. Then you can restore successfully.

For more info follow this link:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/abf50e00-c9b0-4809-9e61-43ed8a53e968/the-media-set-has-2-media-families-but-only-1-are-provided?forum=sqltools

5 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Microsoft SQL Server, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Microsoft SQL Server. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/



    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. I really enjoyed while reading your article, the information you have mentioned in this post was damn good. Keep sharing your blog with updated and useful information.
    MS SQL Server 2016

    ReplyDelete
  5. Thank you for your guide to with upgrade information.
    Sql server DBA Online Training India

    ReplyDelete