Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Low Compression Results

Author  Topic 

vbwrangler
Starting Member

9 Posts

Posted - 2011-06-22 : 15:59:14
We have our first server with SQL 2008 TDE and with both third-party tools SQLBackup by Redgate and with our Virtualization backup tool, vRanger Pro 5, we are seeing 5% or less compression; where 85% was the norm before TDE. Anybody seing respectable backup compression from third-party tools after TDE?

vbwrangler

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-06-22 : 16:26:50
Nope, encrypted data destroys the repetitive patterns that can be easily compressed.
Go to Top of Page
   

- Advertisement -