Red Gate forums :: View topic - TFE Encription
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Object Level Recovery Native 1
SQL Object Level Recovery Native 1 forum

TFE Encription

Search in SQL Object Level Recovery Native 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
CGLuttrell



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

PostPosted: Wed Jun 13, 2012 8:34 pm    Post subject: TFE Encription 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 "Error opening file: Attempted to read past the end of the stream."
Back to top
View user's profile Send private message AIM Address MSN Messenger
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Fri Jun 15, 2012 8:12 am    Post subject: Reply with quote

Thanks for your post.

I wasn't immediately sure if the TDE was likely to be the problem or not (OLR can fail on some backup files just through sheer bad luck) but reading here it does suggest the backups can only be read on the original instance. Our tool doesn't have options to let you specify a certificate or similar.

So I think the only workaround if you need to recover specific objects/data would be to restore your backup as a temporary database then use SQL Compare (and Data Compare if you need to also recover data) to synchronize the objects in question back to the main database.
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