Can SQL Backup backup a database that is using TDE

gsc_ghxgsc_ghx Posts: 73
edited January 18, 2011 10:01PM in SQL Backup Previous Versions
Can RedGate SqlBackup backup a db that is using Transparent Data Encryption ?

Thanks
Geri
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    Yes, but you would need to manually back up your certificates and private key associated with the database to ensure the backup files can be restored on other instances. Also, encrypted databases don't compress well, and would probably take longer to back up compared to a regular SQL Server backup, in addition to chewing up more CPU cycles.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • gsc_ghxgsc_ghx Posts: 73
    Thank you Peter. Again you have been helpful.

    :D
    Geri
    · Share on Twitter
Sign In or Register to comment.