This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
When we use compression and take a full backup, does SQL Server uncompress it for doing restore?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Hi @Chaitanya Kiran ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Hi @Chaitanya Kiran ,
did the answer work for you? Are there any additional questions to this topic?
If you found the answer helpful, it would be great if you please mark it "Accept as answer". This will help others to find answers in Q&A
Regards
Andreas Baumgarten
Hi @Chaitanya Kiran ,
short answer: "yes"
----------
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Andreas Baumgarten
Hi Andreas,
I have a doubt. If restore needs to decompress, then whats the use of backup compression? Because, compression and decompression will use lot of CPU, right?
Hi @Chaitanya Kiran ,
you are right, compressing and decompressing a backup will use CPU. But on the other hand the backup needs less storage.
----------
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Andreas Baumgarten
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,
Seeya
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.
My question was, does SQL Server decompress before doing a restore?