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

问题描述

我已经备份了在另一台运行 SQL Server 2012 express 版本的机器上创建的数据库，我想在我的机器上恢复它，该机器运行相同.我勾选了覆盖现有复选框的复选框，并收到此错误:

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屋！