问题描述
您好，
我在旧实例和新实例上都使用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
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
这篇关于“未选择要恢复的备份集” - 无法将启用了TDE的SQL Server 2014数据库备份还原到新实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！