Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a way to decrypt TDE log files on disk for use with 3rd party software? I have the original key and certificates. I am trying to use the transaction files with a 3rd party tool in order to recover some lost data.

share|improve this question
    
Is there any way to restore the DB first elsewhere? –  Ali Razeghi May 22 '13 at 22:34

1 Answer 1

up vote 2 down vote accepted

Is there a way to decrypt TDE log files on disk for use with 3rd party software?

The short answer is -- this cannot be done.

Encryption of the database file is performed at the page level. The pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory. TDE does not increase the size of the encrypted database.

[...] When the data is written from buffer pool to disk (MDF, LDF & NDF) the data is first encrypted and then then encrypted data will be sent to disk. When the data is read from the disk, first the data will be decrypted and then it will be sent to buffer pool.

Taken from How to enable/remove Transparent Data Encryption (TDE). See also SQL Server 2008 Transparent Data Encryption.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.