Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.7 - Release Notes

Release Notes

LiteSpeed® for SQL Server® 8.9.7

Release Notes

February 2023

These release notes provide information about the LiteSpeed for SQL Server release.


About this release

LiteSpeed for SQL Server, or LiteSpeed, is a fast and flexible backup and recovery solution that allows DBAs to easily maintain complete control over the backup and recovery process. Its low-impact, high-performance compression and encryption technology enables users to reduce storage costs and protect data, while improving both backup and disaster recovery times. With the improved compression and LiteSpeed's Fast Compression technology, LiteSpeed for SQL Server can further reduce disk space and backup time up to another 85% over traditional, compressed full backup solutions. The result is a unique backup and recovery approach, unmatched in flexibility, that greatly reduces backup times, creates a significantly smaller storage footprint, and maintains a high level of recoverability.

  • LiteSpeed 8.9.7 is a minor release,

Key Benefits

  • Store database backups directly into the following cloud platforms: Microsoft Azure Blob storage, Amazon S3, Google Storage and S3 Compatible Storage.

  • Reduce storage requirements to save valuable disk space with Fast Compression (reduce storage and improve backup times up to 85% over traditional full backup solutions)
  • Optimize use of available server resources with LiteSpeed's Adaptive Compression
  • Reduce backup times to improve maintenance windows
  • Reduce restore times to avoid excessive downtime
  • Automate backup testing and running database consistency checks using Automated Restore
  • Easily configure backup jobs and maintenance plans on multiple instances by deploying LiteSpeed Backup Templates
  • Easily configure and monitor Log Shipping using the Create LiteSpeed Log Shipping Plan Wizard and Monitoring tab in the LiteSpeed UI Console
  • Recover data and schema from backups using LiteSpeed's Object Level Recovery
  • Undo critical transactions using LiteSpeed's Transaction Log Reader
  • View backup performance across the enterprise using LiteSpeed's centralized reporting repository
  • Easily manage SQL Agent jobs across multiple servers using LiteSpeed's Job Manager
  • Easily configure maintenance plans across the enterprise using LiteSpeed's Maintenance Plan Designer
  • Easily configure backups cleanup rules with Smart Cleanup Policies
  • Leverage LiteSpeed's advanced engine tuning, including CPU Affinity, CPU Throttling, and Threading options
  • Analyze your environment for best backup performance and identify bottlenecks using LiteSpeed's Backup Analyzer
  • Eight highly optimized levels of compression
  • Secure data using backup encryption up to AES-256

New Features

New features in LiteSpeed 8.9.7:

  • "Select all" check box is added in the Backup Template Deployment Wizard when excluding databases under the Backup Option. While deploying a backup template, on the Backup Options step there is an option to exclude databases in the drop-down menu. Since the user can have large numbers of databases, “Select all” check box is added as an option to select all databases either to exclude all databases or deselect only the smaller number which is not needed. By default, the option is deselected.
  • Add Backup Directory option now can be used through to the Backup Location browse dialogs not just from Backup Browse tab
  • Search bar for SQL Server Groups, SQL Servers and SQL databases is added under the SQL Server tree in the Backup Manager window. To avoid the manual searching/scrolling of Server Groups, SQL Servers or SQL databases, the search bar is added above the SQL Server tree. It is visible in the Backup manager, Log shipping and Maintenance plans.
    NOTE: Search is not searching any created Log Shipping or Maintenance Plans. If an item name contains queried phrase it will be listed as a result. Search is case insensitive. Refresh does not affect the input. There is an option button to clear the input.
  • The Exclude Copy Only check box is now added under the Backup Content step in the Object Level Recovery Wizard window. Copy only backup is a backup that is independent from regular backup, meaning that it will not break the chain of backups and the purpose is to avoid affecting the overall backup and restore procedures for the database.
  • Force a full backup if one has not been created is now added to under the Diff Schedule and T-Log Schedule steps in the Backup Template Wizard window
    NOTE: Select this option to run a force full backup if one has not been created. This is a useful option for differential and transaction log backups that require an initial full backup at first.
  • Load databases from all instances at once option is added under the Backup Manager section. Initialize loading databases for all SQL Servers that are registered.
    NOTE:This action may be time consuming depending on the number of SQL Servers
  • The CloudProxyBufferSize parameter which can be inserted into the .ini file, adjusts the buffer size during the cloud restore process which can enhance the restore performance of the database from the cloud storage.
    NOTE:This feature is included in version starting from (value for CloudProxyBufferSize should be set between 10 and 2000) - (10 is the default value)

For more details please visit the following links:


The following is a list of enhancements implemented in LiteSpeed 8.9.7.

Table 1: General enhancements

Enhancement Issue ID
"Select all" checkbox is added in the Backup Template Deployment Wizard when excluding databases under the Backup Options LS-2357
The Exclude Copy Only backups option is added in the Object Level Recovery Wizard LS-2353
Add Backup Directory button is added in the backup file location browse dialogs LS-2360
Search bar for SQL Server Groups, SQL Server and SQL databases is added under the SQL Server tree in the Backup Manager window LS-2344
“Force a full backup if one has not been created” is added in the Backup Template Wizard window LS-2364
Logging for Cloud Proxy while using Amazon S3 Cloud Storage is implemented LS-2432
Load databases from all instances at once option is added under the Backup Manager section LS-2434
Parameter CloudProxyBufferSize is added in LiteSpeedSettings.ini file under the [litespeed] section LS-2449

Deprecated features

The following is a list of features that are no longer supported starting with LiteSpeed 8.9.7.

Table 2: Features that are no longer supported

Features Issue ID

The QuestKey is deprecated in newer versions of LiteSpeed.

Visit to acquire a new license key

Extended stored procedure xp_memory_size marked as deprecated. It will be removed from the product with version 9.0. LS-1406, LS-1762
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