• I prefer LiteSpeed over SQL native compression. I have been using this for couple of my projects. LiteSpeed provides various compressions levels to use. I went with default which is 1. It saves little over 80% in terms of disk space. LiteSpeed also has integrated Log Shipping in case if you need and also lot of other features. Good Luck.

    Thanks,

    Satish