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!