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.
LiteSpeed Engine for SQL Server is a complementary technology to LiteSpeed for SQL Server (LiteSpeed). By providing LiteSpeed’s compression and encryption functionality in a driver based solution, you can continue using native or third party backup tools, while getting the full advantage and flexibility of LiteSpeed’s time and space saving features.
LiteSpeed for SQL Server is a fast and flexible backup and recovery solution that allows database administrators to easily maintain complete control over the backup and recovery process. LiteSpeed's low-impact, high-performance compression and encryption technology helps reduce storage costs and protect data, while maintaining a high level of recoverability.
The following table compares the different versions of LiteSpeed for SQL Server compatible with LiteSpeed Engine:
|Feature||LiteSpeed 5.2||LiteSpeed 6.0||LiteSpeed 6.1 and higher|
|Can restore backups created with LiteSpeed Engine 1.1.||Yes||Yes||Yes|
|Can restore backups created with LiteSpeed Engine 2.0.||No||Yes*||Yes|
Can create backups that are restorable by LiteSpeed Engine 2.0.
(This functionality may be useful for environments, which only have LiteSpeed Engine installed.)
*—May be not restorable, if encryption options were changed for appended backups.
**—If a backup is created using the new @LSECompatible (xp) and --LSECompatible (command-line) parameters
NOTE: Forward compatibility is not supported.
|Processor||Follow the recommendations for the SQL Server version used.|
25 MB of disk space for installation.
NOTE: The disk space required may vary based on options selected during installation.
Follow the recommendations for the SQL Server version used.
NOTE: The memory required for SQL Server may vary based on the following:
|Monitor & Resolution||SVGA with a minimum resolution of 1024x768.|
Microsoft Windows Server 2003 32-bit and 64-bit (x64) (All Service Packs)
Microsoft Windows Server 2003 R2 32-bit and 64-bit (x64) (All Service Packs)
Microsoft Windows Server 2008 32-bit and 64-bit (x64) (All Service Packs)
Microsoft Windows Server 2008 R2 64-bit (x64) (All Service Packs)
Microsoft Windows Server 2012 64-bit (x64) (All Service Packs)
Microsoft Windows Server 2012 R2 64-bit (x64) (All Service Packs)
Microsoft Windows XP 32-bit and 64-bit (x64) (All Service Packs)
Microsoft Windows Vista 32-bit and 64-bit (x64) (All Service Packs)
Microsoft Windows 7 32-bit and 64-bit (x64) (All Service Packs)
Microsoft Windows 8 32-bit and 64-bit (x64) (All Service Packs)
Microsoft Windows 8.1 32-bit and 64-bit (x64) (All Service Packs)
SQL Server 2000 32-bit and 64-bit (All Service Packs)
SQL Server 2005 32-bit and 64-bit (x64) (All Service Packs)
SQL Server 2008 32-bit and 64-bit (x64) (All Service Packs)
SQL Server 2008 R2 32-bit and 64-bit (x64) (All Service Packs)
SQL Server 2012 32-bit and 64-bit (x64) (All Service Packs)
SQL Server 2014 32-bit and 64-bit (x64) (All Service Packs)
.Net Framework 2.0 or above installed before you install the LiteSpeed Engine Configuration Editor.
Adobe Reader 8 to view the User guide.
Prior to installation you may need to gather the following information:
If you are running Windows on... Select... a 32-bit system LiteSpeedEngineSQLServer.msi a 64-bit system LiteSpeedEngineSQLServer-x64.msi
By default, the application files are installed in the C:\Program Files\Quest Software\LiteSpeed\Engine directory. The following start menu shortcuts are installed during a complete installation:
NOTE: If you do not want, or are unable, to install the .NET Framework on the remote servers, you will not be able to install the LiteSpeed Engine Configuration editor. In this case, select a Custom installation and install only the driver. For more information, see Manage Remote Servers. on how to configure and update the remote server.
This version of LiteSpeed Engine for SQL Server supports automatic upgrade from versions 1.x and 2.x. Run the LiteSpeed Engine 2.0 installer. It will uninstall the previous version automatically and prompt for a reboot. Reboot the computer and complete installation. If it does not start back up after rebooting, you should manually run the installer.