SQL Server 2005/2008恢复数据库时遇到的问题(转)

Preface

在浏览本文之前，请保证已经安装好SQL Server 2005，并且在restore之时遇到问题。

Introduction

本文主要讲述为什么SQL Server 2005 在restore database时会遇到问题。

Section 1 - Restore Problem Description

以下是我打算restore时遇到的problem

===================================

Restore failed for Server 'EVILKILLER-NB\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.Restore.SqlRestore(Server srv)
   at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseOptions.RunRestore()

===================================

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

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

Section 2 - Why? But not solution

以下是Microsoft 负责SQL backup 部分的PM对此问题的回复，简单说，对于只有一个bak file的同学，也就是没有办法可以帮你重新restore DB，只能够在下次back的时候要十分注意！

Refer from:

http://forums.microsoft.com/msdn/showpost.aspx?postid=259647&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=0

PS：错误截图