Thursday, November 12, 2015

Cannot find server certificate with thumbprint when restoring a SQL Server database

I was recently attempting to restore a database backup that I received from a vendor when I suddenly encountered the following error message:

Well, as it turns out, based on this Microsoft support article:, the database was backed up using Transparent Data Encryption (TDE).  Therefore, without the certificate information, I would not be able to restore the backups back to my database server.

If the vendor was willing to provide me with the certificate information, then I could use the following method to restore the database:

However, considering that would probably be a compromise of their security, the best thing to do is as advised in the Microsoft support article:

Alter database testDB set encryption off 

Once TDE encryption is turned off, a backup of the database could be created and then provided to us to restore!

No comments:

Post a Comment