I only have backup of a TDE encrypted SQL Server database–can it be restored it to another server

transparent-data-encryption

My situation is little weird–I have no access to the source database server, but I do have the database backups of a database that is encrypted with TDE. When I restore it to another server, I am getting an error about the certificate.

I cannot access the source master database. How can I restore the encrypted database on another server?

Best Answer

The primary purpose of TDE is that someone can't just take the backup or database files and start up the database on another server. Accordingly, the answer is no, you cannot restore it without restoring the certificate that was used to encrypt it.