+7
Query Result [Microsoft.SqlServer.Management.Common.ExecutionFailureException:Cannot find server asymmetric key with thumbprint '0x30364636353638383632373739364134'. RESTORE DATABASE is terminating abnormally. An exception occurred while executing a Transact-SQL statement or batch.]. Source:
Best answer by Stuart Painter
View originalHi
Please would you provide some more details so we have a little more context about what you are trying to achieve, that will help the Community understand and provide some help.
Reviewing the error, I can make a few assumptions.
The restore error suggests that you have backed up an encrypted SQL database and you are attempting an out of place restore to another server.
I’m assuming the key mentioned in the error is found in the source SQL Server, but isn’t present in the destination server, so decryption fails.
Assuming this is the case, you will need to create a master certificate in the destination server and transfer certificate from the source SQL server before attempting to restore the encrypted database.
That way, on restore, the certificate will be found which will allow the database to be decrypted in the destination server.
Thanks,
Stuart
+7
Exactly we are trying to do out of place restor.
how do i create a master certificate?
Hi
Please take a look at these Microsoft guides for managing TDE keys in SQL Server:
SQL Server and Database Encryption Keys (Database Engine)
Move a TDE Protected Database to Another SQL Server
Thanks,
Stuart
+7
Thank you very much. I was able to resolve the issue with the URL in your response.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
