LiteSpeed for SQL Server version 6.5 - defect or enhancement requests that have been addressed in (73212)

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

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

General

If the destination drive runs out of space to hold the backup file, LiteSpeed aborts but leaves an open SPID.

ST#80772

Server instances exported into SS2005 .regsrvr and SS2000 .csv files cannot be imported into the LiteSpeed UI Console.

ST#62846

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

A backup cannot be restored if the encryption password is longer than 91 characters.

ST#82798

Changing the Init backup set option in LiteSpeed defaults does not affect the default shown in the backup wizard.

ST#53542

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

Should display a warning if the server does not have .NET 2 SP1 installed prior to the installation of LiteSpeed.

ST#77344

Provide an option to ignore a server instance in the XML file to avoid installing LiteSpeed onto this instance.

ST#67324

Maintenance Plans

Fill factor for the index is changed to 100 when using the Rebuild Index task.

ST#84211

Cannot open or convert a native SQL 2005 maintenance plan after LiteSpeed was upgraded to 6.1.

ST#80683

When saving a maintenance plan an error "Retrieving the COM class factory..." may occur.

ST#68674

Maintenance plans tasks other than backup should also have the option to ignore offline databases.

ST#64372

If a plan is disabled and then enabled later again it does not remember schedule settings and defaults to 1 hour interval.

ST#79096

The Copy Only Backup option is not scripted and not saved.

ST#82898

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

IDENTITY data type is not being transferred to the new table.

ST#38827

The @onFileGroup parameter only recovers tables to the PRIMARY filegroup.

ST#44044

Object Level Recovery should check databases for TDE and abort the request immediately if TDE is detected.

ST#66782

Object Level Recovery UI does not support Generate DDL Scripts and Recover of Schema against table names with Japanese characters.

ST#67463

Object Level Recovery may take several hours to complete recovering objects.

ST#81814

"Failed to read objects to recover" error may occur when reading a backup created with the previous LiteSpeed version.

ST#81143

Log Shipping

"The DELETE statement conflicted with the REFERENCE constraint" error may occur when removing a subscriber from a log shipping plan.

ST#83417

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

Central repository may update with the correct information from the local repository.

ST#79503

Maintenance plan history on LiteSpeed activity page is only updated after backup task completes.

ST#65396

TSM

Restoring a TSM backup using 'Restore from database' in UI errors out. 'Restore from Device TSM Backup' must be selected.

ST#70107

The TSM device retry time option is limited by 7 times.

ST#82379

Log Reader

The "Table <table_name> not found" error may occur when reading an offline log of a detached database.

ST#79815

The "Table 'sysfiles1' not found' error may occur when reading SQL Server 2008 offline database.

ST#81383

The "Page <page_details> is out of range" and "Page <page_details> not found" errors may occur when reading an offline database log.

ST#80073

UI

Cannot sort jobs by the 'Enabled' and 'Last Result' columns on the LiteSpeed jobs page.

ST#83647

When standard license is installed, the UI allows to create a Fast Compression job if a database uses the simple recovery model.

ST#80034

Advanced Options selections are not retained after editing a log shipping plan.

ST#82911

Maintenance plan tasks are sometimes displayed incorrectly in the maintenance plan design window and cannot be scrolled to.

ST#83669

Documentation

Better documentation regarding %z variable.

ST#80569

More details about file creation behavior with Fast Compression and Maintenance Plans.

ST#80614