Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.6 - Engine User Guide


About LiteSpeed Engine for SQL Server

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.

  • Configuration Editor—This is a UI application that, among other things, allows you to determine what SQL Server backup files (based on their extension) are going to be compressed and/or encrypted.

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.


Compatibility with LiteSpeed

Compatibility with LiteSpeed for SQL Server

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.

A LiteSpeed Engine backup can be restored with either LiteSpeed or LiteSpeed Engine.

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.)

No No



*—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 implemented in LiteSpeed. See the LiteSpeed 6.x online help for more information. Also, an appended backup is restorable, but the previous backups become invisible.

NOTE: Forward compatibility is not supported.

System Requirements

Before installing LiteSpeed Engine for SQL Server, ensure your system meets the following minimum hardware requirements:

Processor Follow the recommendations for the SQL Server version used.
Disk Space

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:

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
Monitor & Resolution SVGA with a minimum resolution of 1024x768.

and software requirements:

Operating System

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)

Database Software

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)

Additional Software

.Net Framework 2.0 or above installed before you install the LiteSpeed Engine Configuration Editor.

Adobe Reader 8 to view the User guide.


NOTE: The installation and configuration wizard must be run by a user that has administrator and DBA privileges. 

Prior to installation you may need to gather the following information:

  • Licensing information
  • Installation directory for the LiteSpeed Engine Configuration Editor (optional)

To install LiteSpeed Engine

Launch the appropriate .msi file and follow the prompts.

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:

  • Refresh Driver Configuration—To force the driver to re-read configuration when the configuration file is manually updated.
  • Rescan for new Drives—To be able to do compressed backups to the new drives added to your system.
  • LiteSpeed Engine Configuration—To specify backup extensions to be monitored and configure compression and encryption options.

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.

To upgrade LiteSpeed Engine

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.

To uninstall LiteSpeed Engine

  1. Select LiteSpeed Engine for SQL Server from the Add or Remove Programs option in the Control Panel.
  2. After uninstalling LiteSpeed Engine re-boot the server.
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating