TFE Encryption of a database

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

TFE Encryption of a database

Postby CGLuttrell » Wed Jun 13, 2012 8:42 pm

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
 
Posts: 18
Joined: Thu Sep 10, 2009 9:25 pm
Location: Knoxville, TN

Postby Brian Donahue » Mon Jun 18, 2012 11:08 am

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
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am

Postby CGLuttrell » Mon Jun 18, 2012 3:25 pm

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
 
Posts: 18
Joined: Thu Sep 10, 2009 9:25 pm
Location: Knoxville, TN

Postby Brian Donahue » Mon Jun 18, 2012 4:10 pm

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
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests