November 7, 2018 at 7:34 am
I have some encrypted databases on my production server (Windows 2008 R2 / SQL Server 2012 SP4) that were encrypted using TDE. I want to test moving them to my test server as practice so that I'm ready to move them to another production in the future.
A master key has already been created on both the source server and delimitation server. I followed this procedure, but when I go to restore on my test server, I get the message "cannot find server certificate with thumbprint". (see attached).
I don't know if I'm doing something wrong, or if I'm following the wrong procedure? (i.e. Backup the TDE cert, create it on the destination sever, then backup the DBs and restore them).
Thanks.
November 7, 2018 at 7:57 am
WC_Admin - Wednesday, November 7, 2018 7:34 AMI have some encrypted databases on my production server (Windows 2008 R2 / SQL Server 2012 SP4) that were encrypted using TDE. I want to test moving them to my test server as practice so that I'm ready to move them to another production in the future.A master key has already been created on both the source server and delimitation server. I followed this procedure, but when I go to restore on my test server, I get the message "cannot find server certificate with thumbprint". (see attached).
I don't know if I'm doing something wrong, or if I'm following the wrong procedure? (i.e. Backup the TDE cert, create it on the destination sever, then backup the DBs and restore them).
Thanks.
It's not finding he original certificate used for TDE. Not sure what was done in restoring the certificate from the backup file. Try going over the instructions in the documentation and see if you can spot which step might be the problem:
Move a TDE Protected Database to Another SQL Server
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply