--- title: "MS SQLSERVER Error -The media set has 2 media families but only 1 are provided. All members must be provided." description: "MS SQLSERVER Error -The media set has 2 media families but only 1 are provided. All members must be provided." author: "Anonymous User" published: 2015-06-15 updated: 2015-06-15 canonical: https://www.mindstick.com/forum/23294/ms-sqlserver-error-the-media-set-has-2-media-families-but-only-1-are-provided-all-members-must-be-provided category: "mssql server" tags: ["mssql server"] reading_time: 2 minutes --- # MS SQLSERVER Error -The media set has 2 media families but only 1 are provided. All members must be provided. I [am trying](https://answers.mindstick.com/qa/36834/which-two-programming-languages-should-i-master-in-if-i-am-trying-to-get-into-google-or-facebook) to restore a 200mb [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) into SQL 2008 and I [am getting](https://www.mindstick.com/forum/34179/i-am-getting-error-while-assigning-the-data-to-the-array-list) this error "The media set has 2 media families but only 1 are provided. All members must be provided.". I did some [research](https://www.mindstick.com/articles/311609/how-to-research-the-companies-before-applying-to-their-open-positions) and found out that this happens when two [destination](https://yourviews.mindstick.com/story/1451/gorgeous-locations-for-destination-weddings-in-india) files was specified during the backup process. I obviously didn't specify two file destinations while I was [backing up](https://www.mindstick.com/forum/158359/what-are-some-common-techniques-for-backing-up-and-restoring-sql-server-databases), but I am not sure with that coz most [people say](https://www.mindstick.com/interview/22779/why-do-people-say-there-is-modulo-bias-when-using-a-random-number-generator) this happens by accident (facepalm). I did some more googling for possible [solutions](https://www.mindstick.com/articles/12807/product-searching-issues-and-solutions-for-ecommerce-store-advanced-search-autocomplete-suggest) but all were pointing out that the only solution is to redo the backup process or find the other file, which are both not possible in my situation because the server has already been [shutdown](https://yourviews.mindstick.com/view/80957/time-to-shutdown-wet-markets-of-china) and I have already deleted all my files from that server (who knew my .bak file would fail?). But I really need to restore the database in my local machine for some data that we need for the remaining [transactions](https://www.mindstick.com/interview/864/explain-acid-rule-of-thumb-for-transactions) that we have in our site before we shut it down. ## Replies ### Reply by Anonymous User This error occurs if you specify two different backup locations in your INITIAL backup and then attempt to restore from only one of the two backup files that are created during the backup process. If your server is already down and wiped then you are hosed. But for future reference, you need to: Begin the backup wizard process Ensure that only one backup location is specified On the options page, click on 'Back up to a new media set...' and specify a new name and description All future restores from this location should work just fine. Refer this thread **Sql server - Restore failed for Server 'servebrname'.** --- Original Source: https://www.mindstick.com/forum/23294/ms-sqlserver-error-the-media-set-has-2-media-families-but-only-1-are-provided-all-members-must-be-provided Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.