I am currently in the process of restoring a TDE encrypted database to another instance. I have backed up master key and certificate, and have restored them to the new server fine, but I am still incurring the following message -
Msg 33111, Level 16, State 3, Line 1 Cannot find server certificate with thumbprint '0x85187A0021B33712B314113A5F75DBE2EFD118F2'. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.
TDE was set up on the source with a database encryption key ....
CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_128 ENCRYPTION BY SERVER CERTIFICATE TDE_CERT GO
and can be found under
and the thumbprint is of this. I have not restored this to the new server. How do I go about this?
Not understanding how I restore/create this on the new server, or am I going the wrong way about it? Relatively new to dba-ing, so please be gentle.