Red Gate forums :: View topic - TFE Encryption of a database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

TFE Encryption of a database

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
CGLuttrell



Joined: 10 Sep 2009
Posts: 17
Location: Knoxville, TN

PostPosted: Wed Jun 13, 2012 8:42 pm    Post subject: TFE Encryption of a database Reply with quote

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
Back to top
View user's profile Send private message AIM Address MSN Messenger
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Jun 18, 2012 11:08 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
CGLuttrell



Joined: 10 Sep 2009
Posts: 17
Location: Knoxville, TN

PostPosted: Mon Jun 18, 2012 3:25 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message AIM Address MSN Messenger
Brian Donahue



Joined: 23 Aug 2004
Posts: 6581

PostPosted: Mon Jun 18, 2012 4:10 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group