“未选择要恢复的备份集” - 无法将启用了TDE的SQL Server 2014数据库备份还原到新实例 [英] "No backupset selected to be restored" - Cannot restore SQL Server 2014 Database backup with TDE enabled on to a new instance
问题描述
您好，
我在旧实例和新实例上都使用SQL Server 2014，SP2，企业版。我正在尝试将启用TDE的数据库的备份（大约360 GB）还原到新实例。 证书已在源服务器上过期，因此，在源上创建
新证书，然后恢复到新实例。 我还在新实例上创建了主密钥。 我制作了数据库的仅复制备份，并将其复制到新实例所在的服务器上。 当我尝试
恢复数据库时，我不断得到"没有选择要恢复的备份集"。错误群组。恢复Filelistonly和Restore Verifyonly检查备份文件返回时新实例没有问题。 但是，Restore Headeronly返回
，错误如下。
消息3013，等级16，状态1，行118 $
RESTORE HEADERONLY正在终止异常。
尝试失败后，我手动创建了一个空数据库，并在数据库上下文中运行以下命令后启用了加密。
创建数据库ENCRYPTION KEY
WITH ALGORITHM = AES_256
加密服务器证书<证书名称>
现在我想恢复到最顶层使用SSMS的新数据库，但它停留在"读取备份设备头"文件超过一个小时。
请对此有所了解。
提前致谢。
Prasad Koukuntla
Hi
Prasad ，
请与我们分享您恢复数据库的T_SQL代码。我注意到您为数据库进行了仅复制备份。请告诉我们是否还有另一个备份过程同时发生
。
此外，您的
恢复Headeronly 操作是
终止 ed。请为我们提供更详细的错误消息。
顺便说一句，你在哪里存储这些备份文件，在本地位置或网络位置？
最好的问候，
Emily
Hello,
I am using SQL Server 2014, SP2, Enterprise edition, on both old and new instances. I am trying to restore a backup (about 360 GB) of a TDE enabled database on to the new instance. The certificate had expired on the source server, so, created a new certificate on source and then restored on to the new instance. I also created the master key on the new instance. I made a copy-only backup of the database and copied on to the server where new instance is located. When I tried to restore the database I keep getting "No backupset selected to be restored" error. Restore Filelistonly and Restore Verifyonly check on backup file come back with no issues on the new instance. However, Restore Headeronly comes back with error below.
Msg 3013, Level 16, State 1, Line 118
RESTORE HEADERONLY is terminating abnormally.
After this attempt failed, I created a blank database manually and enabled encryption on after running the following in the database context.
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE <cert name>
Now I am trying to restore on top of the new database using SSMS but it is stuck at "Reading backup device header" file for more than an hour.
Please shed some light on this.
Thanks in advance.
Prasad Koukuntla
Hi Prasad,
Could you please share us the T_SQL code that you restored the database. I noticed that you made the copy-only backup for the database. Please tell us whether there were another backup process happened at the same time.
Besides, your Restore Headeronly operation was terminated. Please provide us more detailed error messages for it.
By the way, where did you store these backup files, in the local location or network location?
Best Regards,
Emily
这篇关于“未选择要恢复的备份集” - 无法将启用了TDE的SQL Server 2014数据库备份还原到新实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
