Compression backup restore

Chaitanya Kiran 656 Reputation points

When we use compression and take a full backup, does SQL Server uncompress it for doing restore?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,987 questions
{count} vote

Accepted answer
  1. Andreas Baumgarten 69,566 Reputation points MVP

    Hi @Chaitanya Kiran ,

    short answer: "yes"


    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Andreas Baumgarten

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,296 Reputation points

    Hi @Chaitanya Kiran ,

    Yes. I recommend you to read these.
    Configure Backup Compression (SQL Server)
    Behavior of compressed backups when you append backups to an existing media set
    Here is a point: One of the main restrictions with compressed backups is that compressed and uncompressed backups cannot co-exist in a media set.
    Finally, I suggest you might want to do a test yourself, starting with creating a new test database to get a feel for the change in database size after compression.
    I did a test and now i post my results below:

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.