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 support center
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: 14
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: 6346
Location: Red Gate Software
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
CGLuttrell



Joined: 10 Sep 2009
Posts: 14
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: 6346
Location: Red Gate Software
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.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
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