Standard Plugin Reference

SQL Server Compressed Backup comes with a number of standard plugins.

Database Plugins

These plugins are for communicating with SQL Server.

db

This plugin is the standard plugin for backing up and restoring SQL Server databases. For example:

Compression Plugins

gzip

Compresses the data using gzip compression which is faster than the other standard plugins but has the lowest compression ratio.

zip64

Compresses the data using the zip64 format, which isn't exactly the same as the zip format. The zip format has file size limitations while zip64's limitations are much larger. 7 Zip is an open source windows program which is known to decompress zip64 and many other compression formats.

bzip2

Of the standard plugins, this plugin has the best compression ratio but is the slowest.

LZ4

(Added in 2.0)

This is the only plugin that generates a compressed file that can’t be opened by standard compression tools like 7-zip or winzip. It also produces the largest of all the compressed file formats. The trade off is that it can be substantially faster than any of the other methods.

Encryption Plugins

AES(Rijndael)

(Added in 2.0)

This allows you to encrypt your backups with a pass phrase and is properly salted in the application. Usage:

Resource Plugins

rate

The rate plugin is used to slow the backup to prevent the system from being affected by the backups.

Storage Plugins

Storage plugins save file backups and read backup files when restoring databases. These plugins might be FTP, HTTP, NFS, or local file systems.

local

Saves/reads files on the local file system.

Last edited Oct 31, 2013 at 2:55 AM by SQLServerIO, version 2