HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

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

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
cansqltdeencrypteddatabaseanotherserverrestoredonlyhave

Problem

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?

Solution

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.

Context

StackExchange Database Administrators Q#220725, answer score: 3

Revisions (0)

No revisions yet.