SQL Server Compressed Backup

Documentation

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.

Options

OptionRequiredDescription
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.

Example

The example below compresses the data at level 3.

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