Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.5 - Engine User Guide

Introduction

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

Yes**

 

*—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.

Memory

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.

Installation

If you are running Windows on... Select...
a 32-bit system LiteSpeedEngineSQLServer.msi
a 64-bit system LiteSpeedEngineSQLServer-x64.msi
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