Simply set the compression option on the Options page of the Back up Database dialog. You may be asking yourself: How effective is this compression? The answer can be tricky because it depends on the ...

- @OnlineOnly - 1 causes the script to use ONLINE=ON when performing the compress operation - @CompressionType - can be "PAGE" or "ROW" - @MinObjectSizeGB - the minimum current size of a table/index ...