Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

LiteSpeed for SQL Server - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
Idea Portal
Online Documentation
Video Solution Catalog
Best Practices Webcast
Recasting LiteSpeed backups
Support Technical Training
Contact Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1684
Error converting data type nvarchar to tinyint when edit job from job manager (232484)

When I change a job step (modify or add one) and I click Save I get the error "Error converting data type nvarchar to tinyint". This happens to all the existing jobs. I can successfully modify or add the job step in SSMS. WORKAROUND. None. STATUS. Issue fixed in version 8.6. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/18/2017
(0 Ratings) 58 views
OLR restore error: Failed to insert data into table ... (227925)

Restore error when trying to perform an Object Level Recovery Table Restore: Failed to insert data into table [dawa].[map].[restore5clienttrestore5] cannot fetch a row from OLE DB provider "BULK" for link server "(Null). Sparse ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/18/2017
(0 Ratings) 1 views
LiteSpeed 8.5 performance got slower due to always on addition. (229395)

Following query in Litespeed 8.5 causing slower backup performance. SELECT db.name as [ReplicaDBName], ag.name as [ReplicaGroup], cast(ars.[role] as int) as [ReplicaRole] FROM master.sys.availability_groups ag inner ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/18/2017
(0 Ratings) 277 views
Enhancement Request to have the ability to specify more than one path for the data and log files in the Automatic Restore option (157607)

In the Automatic Restore option is only possible to select one path for the data and an another for the log files so it is not possible to use this feature if user needs more than one path WORKAROUND. None. STATUS. Issue fixed in version 8.6. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/17/2017
(0 Ratings) 4203 views
LiteSpeed does not show TDP/TSM backups (233000)

LiteSpeed does not show TDP/TSM backups. Customer backs up his database with TDP into TSM but these backups are not shown in the console of LiteSpeed. Enhancement request that TSM\TDP backup data be replicated from the MSDB to the Litespeed local. Status: ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 4 views
Newly installed instances of LiteSpeed are not automatically showing up in the Central Repository. (232812)

Newly installed instances of LiteSpeed are not automatically showing up in the Central Repository. The only way to get a new instance of LiteSpeed to show up in the Central Repository is to wipe out the '.list' files and reopen the Console. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 5 views
Maintenance plan creates but does not drop temp tables. (232871)

Maintenance plan creates but does not drop temp tables. We started receiving alerts that our TempDB data file had filled up. We keep TempDB to a fixed size to prevent queries from filling up TempDB and the disk. Upon investigation ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 5 views
Does LiteSpeed support mirror to cloud (AWS S3 and Azure)? (231021)

Does LiteSpeed support mirror to cloud (AWS S3 and Azure)? This option will be available in Mirror to Cloud(s) in Backups, Multi-Database Backups, Templates,and Maintenance Plans. WORKAROUND. None STATUS. Enhancement ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 8 views
Is it possible to backup locally and mirror to cloud(AWS S3 and Azure) or vice versa? (183826)

Is it possible to backup locally and mirror to cloud(AWS S3 and Azure) or vice versa? WORKAROUND None. STATUS. Enhancement request CR118899 / LS-196 has been added in version 8.6. The latest version of Litespeed for SQL Server can. be downloaded here.

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(1 Ratings) 1078 views
Cannot enter my Site Message in LiteSpeed for SQL Server 8.6 (233643)

Cannot enter my Site Message in LiteSpeed for SQL Server 8.6 and if I enter only the license key I got the error "Invalid License": This key works in version 8.5. There have been some internal changes in the licensing of LiteSpeed for SQL Server 8.6. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 16 views
MP delete backups task error "List of Objects in cloud exception: The remote server returned an error: (404) Not Found" (229241)

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 201 views
Getting error "Database 'name' is invalid: not found" during smart cleanup process on fast computers (233544)

See an example of the log file here: 00:40:10.546 4384 SQL Connection::Execute bool Connection::Execute {. 00:40:10.546 4384 SQL Connection::Connect bool Connection::Connect {. 00:40:10.546 4384 SQL Connection::Connect ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/13/2017
(0 Ratings) 14 views
Impossible to restore LiteSpeed backup: File 'E:\Data\XXXXX\YYYYY\test.mdf' is claimed by 'test_2'(3) and 'test'(1). (233392)

Getting error below when trying to restore a backup created by LiteSpeed: Unexpected termination on thread: 3, Return code: x80770004 RESTORE DATABASE is terminating abnormally. File 'E:\Data\XXXXX\YYYYY\test.mdf ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 10/5/2017
(0 Ratings) 7 views
Request that Litespeed records a warning in the repository when network resilience kicks in (233164)

LiteSpeed's read and write resilience can handle various failures on both network and attached storage devices. If LiteSpeed fails to write a backup during a backup operation or fails to read a backup during a restore operation, it will wait and retry the failed operation. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 9/26/2017
(0 Ratings) 5 views
How to keep change data capture (CDC) with restores with xp_restore_automated extended stores procedures. (232468)

How to keep Change Data Capture (CDC) with restores? Change Data Capture. https://technet.microsoft.com/en-us/library/cc645937(v=sql.110). aspx. Status: Enhancement request LS-555 has been submitted to Development for consideration in a future release of LiteSpeed. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 9/15/2017
(0 Ratings) 5 views
Is there any way to configure a backup template for native backups? (232892)

Is there any way to configure a backup template for native backups? No. Templates were specially designed for LiteSpeed Backups. However, it is possible to use the Multi-Database backup feature for native backups.

Product(s): LiteSpeed for SQL Server
Last Updated On: 9/14/2017
(0 Ratings) 6 views
How to determine most recent reboot of a Microsoft server or workstation (50778)

How to determine most recent reboot of a Microsoft server or workstation. To determine when your machine was last rebooted, open a command prompt and enter net statistics workstation | more The second line of text will display Statistics since... ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 9/6/2017
(0 Ratings) 35 views
Is Dell/EMC ECS (Elastic Cloud Storage) supported by LiteSpeed? (230688)

Does the current LiteSpeed version 8.5 support Dell/EMC ECS (Elastic Cloud Storage), or is a version with ECS support planned in the future? LiteSpeed does not currently support Dell/EMC ECS (Elastic Cloud Storage), and no future support is planned at the moment. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/2/2017
(0 Ratings) 1 views
Slow log backup performance and failed writes to S3 (231572)

Degradation of backup performance from minutes to hours. In the local repository database, there can be seen locks on some tables during insert. Locks in database tables in local repository during inserts. Reduce the history data in the local repository database. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/2/2017
(0 Ratings) 2 views
unable to run backup to tsm tape. "Request large buffers failure on backup device" (230818)

In log is a message like this: BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device 'VDI_07A0B63A-7A30-7E93- A986-68D03C63842A_0'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).'. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/2/2017
(0 Ratings) 1 views
How to make a backup job dependent on another finishing? (198616)

I need to know if there is a way to make one job dependent on another finishing. For example, to have backup jobs or integrity check jobs run in sequence for both same and different instances on the same server (so when one job finishes the next one starts). ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/19/2017
(0 Ratings) 703 views
Request the option in the Restore wizard tot keep the original mdf and ldf file names on the target. (206343)

When using the Restore Wizard to restore to a new target server via the LiteSpeed GUI, the mdf and ldf did not keep the same name. Customer is restoring a database to a new server and has to edit the script\UI to keep the original file names. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/19/2017
(0 Ratings) 649 views
Restore a double click file but getting error "failure to load xml data to document object...." (189960)

Since upgrade from 6.1.1 to 8.1, trying to restore a database but getting error "failure to load xml data to document object...." Double click source version is 6.5.0, the target old version was 6.1.1 which user was able to restore using the xp_restore_database command. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/19/2017
(0 Ratings) 600 views
Does Object Level Recovery work with cloud-based storage (AWS S3)? (156095)

Does Object Level Recovery work with cloud-based storage, eg AWS S3? Object Level Restore using Amazon S3 is not supported in Litespeed at this time. Please transfer the file locally, using the S3 web console, or a third-party product. ...

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/6/2017
(0 Ratings) 14999 views
Does LogReader support reading logs from Cloud (AWS and Azure) ? (231020)

Does LogReader support reading logs from Cloud (AWS and Azure) ? WORKAROUND. None. STATUS. Enhancement request number LS-117 has been submitted to Development for consideration in a future release of LiteSpeed for SQL Server

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/4/2017
(0 Ratings) 6 views