“没有选择要恢复的备份集"SQL Server 2012 [英] "No backupset selected to be restored" SQL Server 2012

问题描述

我有一个启用了文件流的 SQL Server 2012 数据库.但是，当我备份它并尝试在另一个 SQL Server 2012 实例(在另一台机器上)上还原它时，我只是收到以下消息:

I have a SQL Server 2012 database with filestream enabled. However, when I backup it and try to restore it on another SQL Server 2012 instance (on another machine), I simply get this message that:

没有选择要恢复的备份集.

No backupset selected to be restored.

甚至没有一行更多的解释.这里有什么问题吗?

Not even a single line of more explanation. What's wrong here?

其他没有文件流的数据库都可以，可以成功恢复.它与文件流有关吗?我应该安装一个修补程序或类似的东西.

Every other database without filestream is OK and can be restored successfully. Is it something related to filestream? Should I install a hotfix or something like that.

推荐答案

我遇到了这个问题，结果我试图恢复到错误的 SQL 版本.如果您想了解有关正在发生的事情的更多信息，请尝试使用以下 SQL 恢复数据库:

I had this problem and it turned out I was trying to restore to the wrong version of SQL. If you want more information on what's going on, try restoring the database using the following SQL:

RESTORE DATABASE <YourDatabase> 
FROM DISK='<the path to your backup file>\<YourDatabase>.bak'

这应该会给你一个你需要调试的错误信息.

That should give you the error message that you need to debug this.

这篇关于“没有选择要恢复的备份集"SQL Server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！