SQL Server Compressed Backup
What is SQL Server Compressed Backup?
SQL Server Compressed Backup is a command line utility for backing up and restoring SQL Server 2005, 2008, 2008 R2 and 2012 databases in various compression formats including gzip, zip64, bzip2 and LZ4.
Origionally written by Clay Lenharts
, msbp has been used by thousands of people to handle their backup and restore needs.
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 are used.
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 day, through an encryption plugin. Any number of plugins, including plugins you
write can be used in the pipeline.
Multi-threaded Compression. SQL Server Compressed Backup can compress your backups using multiple threads to take advantage of multiple cores.
SQL Server Compressed Backup is tested against SQL Server 2005, 2008, 2008 R2, 2012 and requires .Net 4.0 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.
output to screen may be missing bytes completed.
6.86% Complete. Time Remaining: 00:00:05:14
9.98% Complete. 1.45 GB Completed. Time Remaining: 00:00:03:37
This doesn't effect the backup.
Ctrl-c kills the application ungracefully, which isn't ideal.