Quest® LiteSpeed™ for SQL Server

Version 4.8.4

Release Notes

December 6, 2007

Contents

Welcome to LiteSpeed for SQL Server 4.8.4

LiteSpeed for SQL Server is a revolutionary, patented development in database backup technology, encompassing the latest encryption and compression algorithms to deliver a complete solution for your archiving needs. LiteSpeed maximizes disk space and process efficiency while greatly reducing the overhead costs associated with maintaining a state-of-the-art database facility.

LiteSpeed is the new way of backing up SQL Server® databases quickly and securely. Unlike existing technologies, LiteSpeed encrypts and compresses all data as it backs it up, which means that cumbersome compression routines and poor encryption algorithms are things of the past.

The size of the backup file is typically only a fraction of the size of the original backup size, maximizing storage efficiency and ensuring significant savings in disk space. The encryption algorithm ensures that data cannot fall into the wrong hands as it is transported to an off-site backup facility.

Down time and database failures are a reality. Components fail, databases become corrupted, and administrators make mistakes. But by using LiteSpeed, restore time can be reduced and downtime minimized. Mission critical databases can be brought back online quickly and reliably using LiteSpeed’s revolutionary new technology.

Key Benefits:

• Reduced Storage Requirements (up to 95% compression)

• Reduced Backup Times (up to 75% faster than native SQL Server)

• Reduced Restore Times

• Increased Transaction Throughput

• Secure Backup Device Files (256-bit encrypted)

• Reduced Network Load

• Fully Integrated into SQL Server

• Highly Tunable

• User-definable Compression Level

• Choice of Encryption Method: RC2 (40-bit, 56-bit, 112-bit, 128-bit), RC4 (128-bit), 3DES (168-bit), AES (128-bit, 192-bit, 256-bit)

Note: Access to Object Level Recovery requires a Professional license.

Back to Top

New in This Release

Several new features have been added or modified to increase productivity and functionality of LiteSpeed for SQL Server 4.8.4.

Release 4.8.4

• Users with existing SSMS plug-in created jobs can now upgrade their old version jobs to the current version using the conversion wizard.

• The default logging path is now C:\Documents and Settings\All Users\Application Data\Quest\Litespeed, instead of x:\Program Files\Imceda\LiteSpeed\SQL Server\Engine\Logs.

• LiteSpeed 4.8.4 offers partial support for SQL Server CTP 4 and Windows 2008 R0.

• Supported features include: xp_backup_database, xp_restore_database, xp_backup_log, xp_restore_log, xp_sqllitespeed_version, xp_restore_filelistonly, xp_restore_headeronly, xp_restore_verifyonly and scheduling backups and restores via the Enterprise Console.

• Unsupported features include (in particular) the MMC console, SQL Server clusters, Object Level Recovery, the SSMS Plug-in, Tivoli Storage Manager (TSM), and log shipping.

• The OLR process does not work with SQL Server 2008 CTP 5. If initiated, the OLR process must be killed through the Task Manager.

Release 4.8.3

• Localized for English.

• SQL Server 7 supported.

• The Red Server Icon has been redesigned with no change in function.

• The Orange Server Icon (for Reporting) appears in the Enterprise Console Tree if LiteSpeed cannot tell whether SQL Server is running.

Release 4.8.2

• Localized for Japan.

Release 4.8.1

• Fixes a 4.8 issue on x64 and Itanium versions of LiteSpeed that caused restores to fail on backup files that were larger than 4GB.

Release 4.8

• The Red Server Icon (for reporting) appears in the Enterprise Console Tree if a server or database has previously been backed up using LiteSpeed, but there are no recent backups for that server or database (that is, no records of backups exist in the central repository). This icon appears if there are no backups within three days of the last backup and may indicate a problem with the server or the LiteSpeed Activity Service.

• Creating Partial Backups

To create a partial backup, use the BACKUP statement and specify the READ_WRITE_FILEGROUPS option. You can also specify any read-only file or filegroup to include it in a partial backup.

The required syntax for creating a partial backup is:

BACKUP DATABASE database_name

READ_WRITE_FILEGROUPS [ , <file_filegroup_list> ] TO <backup_device>

According to SQL Server 2005's documentation, to cause a partial backup enter:

@read_write_filegroups=1

Note: For additional information refer to Microsoft's SQL Server documentation:

http://msdn2.microsoft.com/en-us/library/ms191539.aspx

• Object Level Recovery Execute SELECT:

Prior to LiteSpeed 4.8, if the destination table already existed you received the error message: 'Failed to create table'. This required the creation of a new table for every query. Thus to create a UNION of SELECT results, it was necessary to CREATE and DROP a temporary table and then move the rows to the more persistent table.

Beginning in LiteSpeed 4.8, if the destination table already exists and is equivalent in structure to the query results, then the rows are inserted into the existing table. For equivalence, the column names of the table and of the query results are not required to be equal, rather the number of columns and the details of the data types of each column are required to be the same. If the table and query results are not equivalent, then the error message 'Existing table <table name> is not equivalent to query results.' is returned. If OLR is unable to accomplish the comparison, the message is 'Unable to describe existing table <table name>.'

• Object Level Recovery on Differential Backups:

Object level recovery commands can now be used on differential backups in addition to full backups.

• Encryption is now available with both Standard and Professional licenses.

Back to Top

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in the  LiteSpeed for SQL Server 4.8.4, 4.8.3, 4.8.2, 4.8.1, and 4.8 releases.

Back to Top

Known Issues

The following is a list of issues known to exist at the time of LiteSpeed for SQL Server 4.8.4 release.

Back to Top

Third Party Known Issues

There are no known third party issues at the time of LiteSpeed for SQL Server 4.8.4 release.

Back to Top

Upgrade and Compatibility

• LiteSpeed log shipping is not compatible with SQL Server 7.

• Clustered systems using encryption under LiteSpeed versions 4.8.2 and before can encounter maintenance plan issues. Customers having the Cluster+Encryption configuration should upgrade to LiteSpeed 4.8.3 or later.

• RC2 encrypted backups created on systems running Windows 2000 can intermittently fail to decrypt on non-Windows 2000 systems. A Microsoft article describing this issue in greater detail can be found at the following location: http://www.support.microsoft.com/kb/841715. Quest Software recommends that Windows 2000 systems use 3DES and above for backup encryption.

• Users upgrading from version 4.0 or previous builds may be asked to reboot – no reboot is required.

• LiteSpeed SSMS plug-in functionality is available on SQL Server 2005 build 9.0.3042.1 and above.  All other SQL Server 2005 versions are unsupported.

Back to Top

System Requirements

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

Back to Top

Global Operation Statement

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 encodings 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 release is localized to the following languages: Japanese.

This release has the following known capabilities or limitations: Log Reader was not translated.

Back to Top

Getting Started

Contents of the Release Package

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

The Installation Guide, with full details on installing LiteSpeed, is contained on the website and the Quest Library. It is called LiteSpeed 4.8.4 Installation Guide.

Installation Instructions

Double-click on the installer (for instance, LiteSpeed.msi for 32-bit) and follow the on-screen directions. See the Installation document for full details on installing LiteSpeed.

After the installer has been run, LiteSpeedHelp.chm is in the directory where LiteSpeed for SQL Server 4.8.4 has been installed.

Back to Top

For More Information

Contacting Quest Software:

Refer to our Web site for regional and international office information.

Contacting Quest Support:

Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.

From SupportLink, you can do the following:

• Quickly find thousands of solutions (Knowledgebase articles/documents).
• Download patches and upgrades.
• Seek help from a Support engineer.
• Log and update your case, and check its status.

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

Back to Top

This document 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.

© 2007 Quest Software, Inc. ALL RIGHTS RESERVED.

Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.

This product includes software developed by:

• JVCL source code that can be obtained from http://jvcl.sourceforge.net

• SynEdit source code that can be obtained from http://synedit.sourceforge.net

• Virtual Treeview source code that can be obtained from http://www.delphi-gems.com

• The Delphi toolbar, which is copyright © 2001-2003 by Alex A. Denisov. All rights reserved.

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

Disclaimer

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.

Back to Top