The media set has 2 media families but only 1 are provided. All members must be provided.

最新推荐文章于 2026-04-13 19:31:31 发布

转载最新推荐文章于 2026-04-13 19:31:31 发布 · 4.1k 阅读

标签

#sql server #file #database #数据库 #path

数据库相关专栏收录该内容

34 篇文章

订阅专栏

本文提供了解决在使用MyLittleBackup尝试恢复SQL Server 2008数据库时遇到的Themediasethas2mediafamiliesbutonly1areprovided.Allmembersmustbeprovided.错误的方法。通过删除备份目的地中的一个路径，确保仅创建一个.bak文件，并使用MyLittleBackup进行恢复。

今天在恢复一sql server 2008数据库时遇到如下错误，

The media set has 2 media families but only 1 are provided. All members must be provided.

下面是该问题的解决方案，

Issue

While attempting to restore your database using MyLittle Backup you receive the following error:


   
    
     The media set has 2 media families but only 1 are provided. All members must be provided.

Cause

This error is due to your backup being divided into more than one part at the time of creating your initial backup file. The backup will need to be repeated so that it is contained in one file only.

In the example screenshot below you will see that there are two paths listed for the backup destination, which will create a backup over two files.