Compredd Diferential TLog backups of databases which are TDE enabled

pokiri 1 Reputation point
2021-07-12T05:10:45.097+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 14,001 Reputation points Microsoft External Staff
    2021-07-12T08:38:41.147+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.