LiteSpeed® Engine for SQL Server allows for seamless data compression and encryption without having to modify existing SQL scripts.
The LiteSpeed Engine solution consists of two parts, which are both installed by default:
File driver component—This does the actual work of compressing and optionally encrypting your SQL Server database backups. It works by intercepting the backup file stream and compressing the results before reaching the actual physical disk. If restoring a database, the operation is reversed, the file stream is decompressed before reaching SQL Server.
With each backup, LiteSpeed Engine generates an .lsi file in the same directory as the SQL Server backup file. It has the same name as the backup file, but is appended with the .lsi file extension. This file is used to map backup information and optimize restore times. If it is deleted or otherwise unavailable at the time of restore, the file will be regenerated using information contained within the backup file.
Once installed and configured, the driver will work transparently in the background, compressing and decompressing and optionally encrypting and de-encrypting your SQL Server backups and restores.