LiteSpeed® for SQL Server

Version 6.5.2

Release Notes

October 14, 2011


Contents

Welcome to LiteSpeed

New in This Release

Resolved Issues and Enhancements

Upgrade and Compatibility
System Requirements Global Operations Getting Started For More Information

Welcome to LiteSpeed for SQL Server

LiteSpeed® for SQL Server 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 its latest patent-pending Fast Compression technology and improved compression, 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.

Key Benefits:


New in LiteSpeed 6.5

Adaptive Compression

The new Adaptive Compression feature provides you with more flexibility over the existing LiteSpeed compression levels. Adaptive Compression maintains optimal backup performance by continually monitoring the backup and dynamically changing the compression level based on available server resources. Backups can be optimized for speed or size, while ensuring they do not interfere with normal server activity.

LiteSpeed Backup Templates

Using the new Backup Template Wizard and the Deployment Wizard you can create a backup template to deploy on multiple instances. A backup template contains a set of backup parameters that describe the types of databases and the types of backups you want to perform. Templates can be easily edited and re-deployed.

Remote Deploy

The updated Remote Deploy Configuration Wizard allows you to easily install or update LiteSpeed on remote SQL Server instances across your enterprise. Usability and stability improvements, including improved cluster install behaviors allow for easy, repeatable, LiteSpeed deployments. See Online Help and Installation Guide for more details.

LiteSpeed Dynamic Name Variables (% variables)

If backing up to a network share, you can use the new %SERVER% and %INSTANCE% variables in scripts to create unique backup names across the enterprise. Also, you can now use any of LiteSpeed's % variables to define the backup file format in Maintenance Plans.

Network Resilience

Network Resilience UI options are now supported in the Restore Wizard.

Default Compression

To take better advantage of compression level improvements found in recent releases, the default compression level has been changed from 1 to 2.

Double Click Restore Executables

You can now convert a native SQL Server backup to a Double Click Restore executable.


Resolved Issues and Enhancements

Resolved Issues in LiteSpeed 6.5.2

The following is a list of issues addressed and enhancements implemented in this release of LiteSpeed:

Feature Resolved Issue Issue ID
SQL Server Support Added support for CTP3 release of SQL Server 2012 (code named "Denali"). n/a
Restore Wizard The Restore Wizard may generate duplicate file names for a restore. ST#88323
Maintenance Plans HTML reports are not sent to email recipients after upgrade. ST#90555

Resolved Issues in LiteSpeed 6.5.1

The following is a list of issues addressed and enhancements implemented in LiteSpeed 6.5.1:

Feature Resolved Issue Issue ID
Installation Automatic cluster installation may fail on a passive node. ST#86763
Backup and Restore LiteSpeed may fail to overwrite old Double Click Restore backups. ST#86861
Fast Compression job may hang after the backup completed. ST#86321
Backup to TSM may fail if the filespace name is longer than 99 characters. ST#87655
Backing up with the "Optimize Object Level Recovery speed" option may cause the "Unable to access Temp directory () for OLR Map generation" error. ST#87491
Backup Cleanup Smart Cleanup only removes one file in a multi-stripe backup. ST#86365
Backups to UNC path are not deleted by the maintenance plan cleanup task or the "Remove files older than" option. ST#86326
Object Level Recovery Object Level Recovery may fail to recover a table if an empty system page is found. ST#86076
Object Level Recovery may fail to recover a table with a persisted computed column. ST#63060
Object Level Recovery should support the LIKE operator in queries. ST#71016
Maintenance Plans Backup to TSM may fail with the error 'Unable to create backup sub directory "<name>". Error: "Access is denied"'. ST#86319
Rebuild index task does not work on LiteSpeed local. ST#84934
HTML reports are only created if the user also selects to create a text report. ST#86516
Documentation Syntax example for xp_restore_database is incorrect. ST#86530

Resolved Issues in LiteSpeed 6.5.0

The following is a list of issues addressed and enhancements implemented in LiteSpeed 6.5.0:

Feature Resolved Issue Issue ID
General If the destination drive runs out of space to hold the backup file, LiteSpeed aborts but leaves an open SPID. ST#80772
Backup and Restore

LiteSpeed replaces double quotes with single quotes before sending the SQL to SQL Server.

Any scripts that may be using double quotes need to be reviewed and changed prior to upgrading.

Incorrect, will fail in LiteSpeed 6.5:

exec master.dbo.xp_restore_database
@database = N'Test'
,@filename = N'C:\temp\AdventureWorks_full_1309016094.bak'
,@with = N'REPLACE'
,@with = N'MOVE N"AdventureWorks" TO N"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test.mdf"'
,@with = N'MOVE N"AdventureWorks_log" TO N"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_log.ldf"'

Correct:

exec master.dbo.xp_restore_database
@database = N'Test'
,@filename = N'C:\temp\AdventureWorks_full_1309016094.bak'
,@with = N'REPLACE'
,@with = N'MOVE N''AdventureWorks'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test.mdf'''
,@with = N'MOVE N''AdventureWorks_log'' TO N''C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Test_log.ldf'''

ST#83448
Remote Deploy

Ability to run LiteSpeed wizards, such as Remote Deploy and Instance Configuration using an account with no access to SQL Server.

ST#61006
Maintenance Plans Fill factor for the index is changed to 100 when using the Rebuild Index task. ST#84211
Object Level Recovery Object Level Recovery may fail to read a backup with the "LSM File generation is not available" error. ST#82080
The "Not null column was null" error may occur when restoring a table. ST#79421
UI does not script out objects for recovery. ST#75921
Backup Activity If databases or SQL instances were renamed, the Update Native Backup statistics jobs can fail with the error "Cannot insert the value NULL into column 'DatabaseID'". ST#82797
Other Issues

Information on other resolved issues may be found in the Quest SupportLink Knowledgebase under SOL73212. These resolved issues include the following change requests: ST#38827, ST#44044, ST#53542, ST#62846, ST#64372, ST#65396, ST#66782, ST#67324, ST#67463, ST#68674, ST#70107, ST#77344, ST#79096, ST#79503, ST#79815, ST#80034, ST#80073, ST#80569, ST#80614, ST#80683, ST#81143, ST#81383, ST#81814, ST#82379, ST#82798, ST#82898, ST#82911, ST#83417, ST#83647, ST#83669.

n/a

Known Issues

For information about the issues known to exist at the time of this release, see the LiteSpeed Online Help topic "Review Known Issues".

Back to Top


Upgrade and Compatibility

Version 6.x of LiteSpeed for SQL Server uses a new license format that differs from previous 4.x/5.x versions of LiteSpeed.

For existing customers:

For trial customers:

For more information about registering LiteSpeed and for upgrade instructions, please see the LiteSpeed Installation Guide.

Repository Compatibility

If receiving the message "The version of the <RepositoryDatabaseName> on server <ServerName> is greater than the version of this release of LiteSpeed for SQL Server", please see the online Help topic "Upgrade Repositories". The message is an indication that the statistics agent on the older server does not match the newer version of LiteSpeed and must be upgraded.

In addition, there are special considerations if you are upgrading from LiteSpeed 4.x. Review the following before upgrading from LiteSpeed 4.x to LiteSpeed 5.0 or later:

Maintenance Plans

LiteSpeed 5.x and later do not support SSMS plug-in functionality. However, the LiteSpeed Console allows you to read SSMS plug-in maintenance plans and upgrade them to SSIS LiteSpeed maintenance plans.

There are two ways to remove old backup files for maintenance plans: the 'Clean up maintenance plans' task and the 'Remove files older than' option in the 'Back Up Database' task. The 'Remove files older than' option removes both LiteSpeed 4.8 and LiteSpeed 5.x/6.x backup files for legacy plans. However, for SSIS maintenance plans it only removes LiteSpeed 5.x/6.x backup files. The 'Clean up maintenance plans' task removes LiteSpeed 4.8 and LiteSpeed 5.x/6.x backup files.

LiteSpeed Activity

The timeline on the LiteSpeed Activity tab does not display activity from certain kinds of jobs if you upgrade from LiteSpeed 4.x. You can manually correct this by following Solution 45390 on SupportLink.

Log Shipping

Versions 5.1 and later of LiteSpeed do not support LiteSpeed 4.x log shipping plans. If you are upgrading and have LiteSpeed 4.x log shipping plans, you must follow Solution 45391 on SupportLink to update your log shipping plans. If you do not follow these instructions, your log shipping plans will fail after the upgrade is complete.

The SQL Server versions supported for log shipping depend upon the LiteSpeed release:

SQL Server  4.8 5.0.0 5.0.1 5.0.2  5.1.0–6.5.1 6.5.2
2000
2005
2008 / R2
2012          


System Requirements

Before installing LiteSpeed, ensure your system meets the following minimum hardware and software requirements:

Software Requirements

Operating System

Microsoft Windows 2000 32-bit (Service Pack 4)

Microsoft Windows 2003 32-bit, 64-bit (x64, Itanium) (All Service Packs)

Microsoft Windows XP 32-bit and 64-bit (x64) (All Service Packs)

Microsoft Windows Vista 32-bit and 64-bit (x64) (Service Pack 1)

Microsoft Windows 2008 32-bit and 64-bit (x64, Itanium) (Service Pack 1)

Microsoft Windows 2008 R2 64-bit (x64, Itanium)

Microsoft Windows 7 32-bit and 64-bit (x64)

Database Software

SQL Server 7 32-bit (Service Pack 4)

SQL Server 2000 32-bit and 64-bit (Itanium) (All Service Packs)

SQL Server 2005 32-bit and 64-bit (x64, Itanium) (All Service Packs)

SQL Server 2008 32-bit and 64-bit (x64, Itanium)

SQL Server 2008 R2 32-bit and 64-bit (x64, Itanium)

SQL Server Code Name "Denali" 32-bit and 64-bit

Additional Software

.Net Framework 2.0 Service Pack 1 or higher installed before you install the LiteSpeed UI Console.

If using Tivoli Storage Manager (TSM), the TSM API and Backup/Archive Client version 5.3 or later should be installed.

Microsoft Internet Explorer 6.0 or later.

Adobe Reader 8 or later to view PDF guides.

Hardware Requirements

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

250 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 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 SVGA with a minimum resolution of 1024x768

Supported Cluster Environments

VMWare and Hyper-V Environments

LiteSpeed has been tested and is certified to work under VMWare and Hyper-V environments.


Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encoding and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.


Getting Started

Contents of the Release Package

The LiteSpeed for SQL Server release package contains the following products:

Installation Instructions

Double-click on the appropriate installer (.msi file) and follow the on-screen directions. See the LiteSpeed Installation Guide for full details on installing LiteSpeed. The Installation Guide is located on the product web site and the Quest SupportLink.


For More Information

Contact Quest Software

Email

info@quest.com

Mail

Quest Software, Inc.

World Headquarters

5 Polaris Way

Aliso Viejo, CA 92656 

USA

Web site

www.quest.com

See our web site for regional and international office information.

Contact Quest Support

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a Quest product and have a valid maintenance contract. Quest Support provides unlimited 24x7 access to SupportLink, our self-service portal. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

View the Global Support Guide for a detailed explanation of support programs, online services, contact information, policies and procedures. The guide is available at: http://support.quest.com.


 

© 2011 Quest Software, Inc.
ALL RIGHTS RESERVED.

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.

The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact:

Quest Software World Headquarters
LEGAL Dept
5 Polaris Way
Aliso Viejo, CA 92656
email: legal@quest.com

Refer to our Web site (www.quest.com) for regional and international office information.

Patents

This product includes patent pending technology.

Trademarks

Quest, Quest Software, the Quest Software logo, AccessManager, ActiveRoles, Aelita, Akonix, Benchmark Factory, Big Brother, BridgeAccess, BridgeAutoEscalate, BridgeSearch, BridgeTrak, BusinessInsight, ChangeAuditor, CI Discovery, Defender, DeployDirector, Desktop Authority, Directory Analyzer, Directory Troubleshooter, DS Analyzer, DS Expert, Foglight, GPOADmin, Help Desk Authority, Imceda, IntelliProfile, InTrust, Invirtus, iToken, JClass, JProbe, LeccoTech, LiteSpeed, LiveReorg, LogADmin, MessageStats, Monosphere, NBSpool, NetBase, NetControl, Npulse, NetPro, PassGo, PerformaSure, Point, Click, Done!, Quest vToolkit, Quest vWorkSpace, ReportADmin, RestoreADmin, ScriptLogic, SelfServiceADmin, SharePlex, Sitraka, SmartAlarm, Spotlight, SQL Navigator, SQL Watch, SQLab, Stat, StealthCollect, Storage Horizon, Tag and Follow, Toad, T.O.A.D., Toad World, vAutomator, vConverter, vEcoShell, VESI,vFoglight, vPackager, vRanger, vSpotlight, vStream, vToad, Vintela, Virtual DBA, VizionCore, Vizioncore vAutomation Suite, Vizioncore vEssentials, Vizioncore vWorkflow, WebDefender, Webthority, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. For a complete list of Quest Software’s trademarks, please see http://www.quest.com/legal/trademark-information.aspx. Other trademarks and registered trademarks are property of their respective owners.