TDE and Red-Gate backups

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

TDE and Red-Gate backups

Postby dbenoit » Fri Oct 26, 2012 3:51 pm

Is the data in the Red-Gate SQL Backup actually encrypted for a backup of a database that has TDE applied?
David
dbenoit
 
Posts: 6
Joined: Mon Jun 09, 2008 3:23 pm

Postby petey » Mon Oct 29, 2012 2:16 am

Yes, it is. SQL Backup does not check if TDE is in use when it is requested to perform a backup.

Are you looking for an option to skip encryption when TDE is in use, when performing a multi-database backup?
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm

Postby dbenoit » Mon Oct 29, 2012 2:40 pm

Thanks, Petey. I was just wanting to verify that the data in the backup file was still encrypted and not decrypted prior to being dumped to disk.

I wasn't looking for a way to skip encryption when TDE is in use, but that seems like that would be pretty easy to script around.

Thanks again!
David
dbenoit
 
Posts: 6
Joined: Mon Jun 09, 2008 3:23 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests