SQL Server Compressed Backup


Gzip Plugin Reference

The Gzip plugin is used for compressing backups. The Gzip plugin is faster at compression, but the file size will be larger than other compression plugins. There is no limit to the size of data that can be compressed or uncompressed.


levelNoThe compression level from 1 to 9 to use. 1 is the fastest, and 9 is the slowest. The default is 9. This option is ignored when restoring a database.


The example below compresses the data at level 3.

msbp.exe backup "db(database=model)" "gzip(level=3)" "local(path=c:\model.bak.gz)"