After enabling TDE Encryption my database backup file .bak is 3x larger than before. Is there a way to improve this? Is this due to compression not being as efficient on an encrypted file?
SQL Server – TDE Encryption Tripled Size of Backup Files
backupsql servertransparent-data-encryption
Related Question
- SQL Server – Understanding TDE Restored DB Encryption State
- SQL Server TDE Encryption – Will TDE Protect My Database from Hackers?
- SQL Server TDE – Database Backups and Post Restore Behavior
- SQL Server – Internals of Backup Compression with TDE
- Sql-server – Should I backup Master key / Service master key if I’m using TDE
Best Answer
Correct.
Without removing TDE? No.
Yes.
You don't mention your version, but this has apparently been fixed/improved/added in SQL 2016:
Backup Compression for TDE-enabled Databases
Take note of the warning on this post, there were apparently some potential for corruption that was resolved with a later patch.