我正在恢复SQL数据库备份我收到以下错误 [英] I am restoring SQL DB backup I am getting following error

问题描述

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)

我尝试过：

What I have tried:

I am restoring SQL DB Backup i am getting following error. i don't have any other backup. how to restore please help me 

推荐答案

此错误消息表示您的数据库备份是条带化的，备份流是分成两个目标文件。您正尝试从单个备份文件还原。您需要两个文件来恢复数据库。

This error message means that the your database backup was striped and the backup stream was split into two destination files. You are trying to restore from a single backup file. You need both files to restore your database.

这篇关于我正在恢复SQL数据库备份我收到以下错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！