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.
12,639 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    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