LiteSpeed® for SQL Server
October 14, 2011
|Upgrade and Compatibility|
|System Requirements||Global Operations||Getting Started||For More Information|
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.
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.
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.
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.
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 UI options are now supported in the Restore Wizard.
To take better advantage of compression level improvements found in recent releases, the default compression level has been changed from 1 to 2.
You can now convert a native SQL Server backup to a Double Click Restore executable.
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|
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|
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:
Ability to run LiteSpeed wizards, such as Remote Deploy and Instance Configuration using an account with no access to SQL Server.
|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|
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.
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
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.
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:
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.
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.
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:
|2008 / R2||•||•||•||•||•|
Before installing LiteSpeed, ensure your system meets the following minimum hardware and software requirements:
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)
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
.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.
|Processor||Follow the recommendations for the SQL Server version used.|
250 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 may vary based on the following:
|Monitor||SVGA with a minimum resolution of 1024x768|
LiteSpeed has been tested and is certified to work under VMWare and Hyper-V environments.
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.
The LiteSpeed for SQL Server release package contains the following products:
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.
Quest Software, Inc.
5 Polaris Way
Aliso Viejo, CA 92656
See our web site for regional and international office information.
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
5 Polaris Way
Aliso Viejo, CA 92656
Refer to our Web site (www.quest.com) for regional and international office information.
This product includes patent pending technology.
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.