TDE Enabled Log shipped Backup Compression in SQL Server

As you know that while backing up a TDE-enabled database, the compression will work in ONLY if 

  • MAXTRANSFERSIZE is specified in the BACKUP command. 
  • Moreover, the value of MAXTRANSFERSIZE must be greater than 65536 (64 KB). 
  • It is recommended that you determine your optimum MAXTRANSFERSIZE through testing, based on your workload and storage subsystem. 
  • The default value of MAXTRANSFERSIZE for most devices is 1 MB, however, 
  • if you rely on the default, and skip specifying MAXTRANSFERSIZE explicitly in your BACKUP command, compression will be skipped.

But this setting does not work on the database under LogShipping until the last cumulative update release.

No comments:
Write comments

Please do not enter spam links

Meet US


More Services