sql server恢复备份错误 [英] sql server restoring back up error

问题描述

我已经备份了在另一台运行SQL Server 2012 Express Edition的计算机上创建的数据库，我想在运行同一台计算机的计算机上还原该数据库.我勾选了覆盖现有复选框的复选框，并得到以下错误:

I have backed up a database I had created on an other machine running SQL server 2012 express edition and I wanted to restore it on my machine, which is running the same. I have ticked the checkbox overwriting existing one, and got this error:

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

推荐答案

如果在进行备份时在备份目标文本框中列出了多个文件，则会发生这种情况.返回您的源服务器并再次创建备份；这次，请确保仅列出了一个目标文件.

This happens if, when you made the backup, you had multiple files listed in the backup destination textbox. Go back to your source server and create the backup again; this time, make sure there's only one destination file listed.

如果列出了多个文件作为备份目标，则备份将在它们之间进行条带化；您将需要所有文件来执行还原.

If you had more than one file listed as the backup destination, the backup is striped across them; you'll need all the files to perform the restore.

您可以通过对复制到目标服务器的单个文件执行RESTORE LABELONLY来验证这一点.

You can verify this by performing a RESTORE LABELONLY against the single file you copied to your destination server.

这篇关于sql server恢复备份错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！