Calculate Database Compression Ratio

Here’s a quick and easy formula to help show upper management how much your backup compression strategy is saving the company.

Let’s assume your original non-compressed SQL backup file is 100MB. After you enabled compression your compressed backup size is now 5MB. Plug in the numbers below and you get:

Percent decrease = (OriginalSizeofDB – CompressedSizeofDB) ÷ OriginalSizeofDB.

= (100 – 5) ÷ 100

= .95 = 95%

So in the above scenario by simply enabling database backup compression, you saved 95% of disk space per backup file. Neat!

Leave a Reply

Your email address will not be published. Required fields are marked *