What are the challenges you face when working across database platforms? Take the survey

TDE and Red-Gate backups

dbenoitdbenoit Posts: 10
edited October 29, 2012 9:40AM in SQL Backup Previous Versions
Is the data in the Red-Gate SQL Backup actually encrypted for a backup of a database that has TDE applied?


  • Options
    peteypetey Posts: 2,358 New member
    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 8
  • Options
    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!
Sign In or Register to comment.