question

pokiri-6646 avatar image
0 Votes"
pokiri-6646 asked AmeliaGu-msft commented

Compredd Diferential TLog backups of databases which are TDE enabled

After enabling TDE on production database on SQL Server 2017, Full backup is getting compressed, but Differential and Transaction Log backups are not getting compressed. Any changes to be done for compression to work.

We are already using MaxTransferSize as 1 MB

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi pokiri-6646,

Was your issue resolved?
If the replies could help you, please kindly accept the useful reply as answer to help other community members find the helpful reply quickly. If you have any question, please feel free to ask.

Best Regards,
Amelia

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi pokiri-6646,

Could you please share us the result of “Select @@version” and the query you used to make compressed Differential and Transaction Log backups?
Please use the following query to check if the backup file is compressed:

 RESTORE LABELONLY FROM DISK = ‘physical_backup_device_name’

IsCompressed =1 means the backup is compressed.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.