How can we help you today? How can we help you today?

TFE Encryption of a database

Am I correct that this tool cannot read backups of databases encripted with TFE and a certificate? That is my experience, if I select one of those database backups it says "One or more of the backup files you selected are in valid". Is there anyway to read from those or plans to try to add this? I have access to the certificate the database uses for implementing TFE encryption. I used to compare and recover from backups all the time before we switched to 2008 and implemented TFE.
Thanks,
Chris
CGLuttrell
0

Comments

3 comments

Sort by
  • Brian Donahue
    If you mean TDE encryption, SQL Backup does work with databases that use that encryption scheme. However, like with native or any other type of backup, you have to install the encryption certificate on the destination server when restoring to a different server in order to read the database. SQL Backup will not do that for you.
    Brian Donahue
    0
  • CGLuttrell
    Yes, I meant TDE, sorry aobut that, but I am not talking about SQL Backup. This is about the Compare products and we do not use SQL Backup.
    CGLuttrell
    0
  • Brian Donahue
    Oh, I'm sorry about that.

    Most people ask this question about backup.

    I don't see why SQL Compare wouldn't work with TDE as the encryption is just done on the storage end and all of the queries return unencrypted data through the pipe.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.