What is SQL Server Compressed Backup?
SQL Server Compressed Backup is a command line utility
for backing up and restoring SQL Server 2000, 2005 and 2008 databases in
various compression formats including gzip, zip64, and bzip2.
- Open Source. SQL Server Compressed Backup
is released under GPL v3.
- Compress on the Fly. SQL Server Compressed Backup
compresses the data as it saves the data. No temporary files
- Standard Formats. Your data is important, so it
stores the data in a standard SQL Server *.bak file, compressed
in standard gzip, zip64, or bzip2 formats so that it is easy to
restore the database using the method you are most comfortable with.
Though SQL Server Compressed Backup can also decompress
and restore on the fly.
- Reliable. SQL Server Compressed Backup faithfully stores
the bytes that SQL Server writes and
compresses with well known and reliable compression formats.
The uncompressed data is in the same format as the standard
BACKUP DATABASE command.
- Pipeline Architecture. SQL Server Compressed Backup uses
a pipeline architecture to backup the data. This allows you to pass the
data through a compression plugin, and then, one
through an encryption plugin (when an encryption plugin exists). Any number
of plugins, including plugins you
write can be used in the pipeline.
- Multithreaded Compression. SQL Server Compressed Backup
can compress your backups using multiple threads to take advantage of
- Stable: See project page
- Cntl-c kills the application ungracefully, which isn't ideal.
SQL Server Compressed Backup is tested against SQL Server 2000, 2005 and 2008 and
requires .Net 2.0 which is usually installed
with SQL Server 2005 and 2008. This application must run locally with SQL Server.
Simple. Unzip the files on the server and open a command prompt to execute msbp.exe. If you
execute the *.exe from the command prompt without any arguments, it will
print the help to get you started.