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.
| Author |
Topic |
|
yhchan2005
Starting Member
26 Posts |
 Posted - 2011-10-20 : 23:45:14
|
| Hi,i am using the Data Compression ( for those big table ) + Backup Compression ( to cover those small table which is not use Data Compression ) in my production DB. Adding in the TDE, notice that the backup compression will become useless.would like to double check:if a table got Data Compression, is the Compression come first then Encryption and final IO write ? meansSQL Server step for Data Compression + Encryptionstep 1) Data Compression step 2) Encryptionstep 3) IO Writeorstep 1) Encryptionstep 2) Data Compression step 3) IO Writewhich 1 is the correct sequence ?and also i am using Log Shipping, would like to check the Trx Log Backup will return back to the same size as before compress ? eg Previously i have a TrxLog backup file which size around 100MB ( before compress ) and after i enable the Backup Compression, the size is become 10MB only. If i enable the TDE, the Trx Log backup size will become 100MB ?Thanks. |
|
|
|
|
|
Database Compression + Encryption ( TDE )