TFE Encription

Recovers database objects from SQL Server backups

TFE Encription

Postby CGLuttrell » Wed Jun 13, 2012 7:34 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 "Error opening file: Attempted to read past the end of the stream."
Posts: 30
Joined: Thu Sep 10, 2009 8:25 pm
Location: Knoxville, TN

Postby james.billings » Fri Jun 15, 2012 7:12 am

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.
Posts: 1122
Joined: Wed Jun 16, 2010 10:10 am
Location: Red Gate

Return to SQL Object Level Recovery Native 1

Who is online

Users browsing this forum: No registered users and 0 guests