Chat now with support
Chat with Support

We are currently performing website maintenance, any feature requiring sign-in is temporarily unavailable, if you have an issue requiring immediate assistance please call Technical Support.

LiteSpeed for SQL Server - Knowledge Base

Filter Your Results

Category

Product Version

Topic

Subtopic

Filter Search Results

Search Knowledge Base by keyword

(Choose different product)



DateRelevanceViews Displaying 1-25 of 2276
What's New in Litepeed for SQL Server 8.9.7 (4368765)

A new release of LiteSpeed for SQL Server 8.9.7 is now available. ... check box is added in the Backup Template Deployment Wizard when excluding databases under the Backup Option. ... While deploying a backup template, on the Backup Options step there is an option to exclude databases in the drop-down menu.

Product(s): LiteSpeed for SQL Server
Last Updated On: 5/7/2023
NA rating | 405 views
FAQ
LiteSpeed legacy licensing deprecated for SQL Server 8.9.7 (4368844)

LiteSpeed for SQL Server version 8.9.5 (and earlier versions) allows users to apply a legacy key license to register the application. ... However, if the user is using LiteSpeed for SQL Server 8.9.7 or later then a new license would need to be acquired in order to continue using the application.

Product(s): LiteSpeed for SQL Server
Last Updated On: 5/7/2023
1 rating | 763 views
FAQ
The query processor ran out of stack space during query optimization" error is encountered when creating a backup of a database with many filegroups. (4377499)

The query processor ran out of stack space during query optimization" error is encountered when creating a backup of a database with many filegroups. ... Create a large number of file groups (the issue starts manifesting at above 2000-2200 on current dev machines, but it varies with available memory)

Product(s): LiteSpeed for SQL Server
Last Updated On: 11/4/2024
NA rating | 434 views
Knowledge Article
LiteSpeed Maintenance plan cleanup history fails with error code 0xC002F210 - SQL 2022 (4376875)

SQL Server 2022 does not include ODBC driver as part of the setup. ... The ODBC driver is a LiteSpeed pre-requisite.<br> <p>Install SQL Native Client 12 </p> ... <p>https://www.microsoft.com/en-US/download/details.aspx?id=50402?1558859051</p>

Product(s): LiteSpeed for SQL Server
Last Updated On: 9/4/2024
NA rating | 541 views
Knowledge Article
LiteSpeed repository maintenance - LitespeedActivity Table (4344510)

LiteSpeed repository maintenance - LitespeedActivity Table The LitespeedActivity Database may grow too large over time and may require archiving or maintenance. ... <ul><li>Clean Up History task.

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/27/2024
NA rating | 369 views
Knowledge Article
LiteSpeed Delete Activity not deleting records from Central Database (4376872)

<br>Even with different parameters, is completed instantly without deleting any records. ... This can also happen with the LiteSpeedLocal database. ... The most probable issue is that the LiteSpeed store procedures are not registered correctly in the server where the LiteSpeed database is hosted, either the Central or the Local database.

Product(s): LiteSpeed for SQL Server
Last Updated On: 9/3/2024
NA rating | 494 views
Knowledge Article
Subscriber Properties is showing incorrect value. (4368493)

Log shipping Subscriber is showing data incorrect even though it has been changed. ... Eg: Disconnect users is set to true but it is showing false. ... Click on the Book Icon on the top Left before Home ->Navigate to Options ->Go to Logshipping tab

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/20/2024
NA rating | 512 views
Knowledge Article
How does the backup compression works in LiteSpeed for SQL Server (4376703)

Where does the backup compression takes place in LiteSpeed. ... NA During the backup process compression is done by LiteSpeed. ... A command is sent to SQL Server to perform the backup, and then LiteSpeed compresses the backup.

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/20/2024
NA rating | 548 views
Knowledge Article
occasional backup job failures: "You are attempting to backup a database with multiple operations". (4256514)

Getting error "You are attempting to backup a database with multiple operations" when running a Fast Compression(FC) template against a database that is in restoring status. ... Would it be possible that fast compression template job skips databases in a restoring state?

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/20/2024
NA rating | 746 views
Knowledge Article
Is it possible to set a parameter at Litespeed to divide automatically the large databases into several packages when they reach a specific size? (4329243)

This causes all backups that take longer than 180 minutes to terminate. ... Is it possible to set a parameter at Litespeed to divide the large databases into several packages so that this abort doesn't happen anymore?

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/9/2024
NA rating | 778 views
Knowledge Article
Is it possible to use an AWS IAM role with the xp_slsSmartCleanup procedure, rather than an AWS access and secret key? (4306318)

Is it possible to use an Amazon Web Services (AWS) IAM role with the xp_slsSmartCleanup procedure, rather than an AWS access and secret key? <p>“IAM roles” is a global AWS cloud setting within Litespeed.<br>All Litespeed procedures should use those same cloud settings.</p>

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/9/2024
NA rating | 557 views
Knowledge Article
Enhancement Request to have the ability to specify more than one path for the data and log files in the Automatic Restore option (4299361)

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 <p>WORKAROUND</p>

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/9/2024
NA rating | 581 views
Knowledge Article
OLR fails to start when process has more than 200 TLOG backups (4329770)

Error with OLR appears when trying to restore database + over 200 logs: ... Failed to read objects to recover. ... Error starting process 'C:\Program Files\Quest Software\LiteSpeed\SQL Server\engine\ORL.exe',Error:0xce

Product(s): LiteSpeed for SQL Server
Last Updated On: 8/9/2024
NA rating | 428 views
Knowledge Article
Restore Transparent Data Encryption (TDE) LiteSpeed Backup fails with code 995 (4224959)

When restoring a LiteSpeed backup of an encrypted database by executing T-SQL that opens the master key and executes stored procedure master.dbo.xp_restore_database with move on a SQL instance that is not the backup source, the execution fails with the following error:

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/10/2024
1 rating | 695 views
Knowledge Article
slsRecast returned errors changing the backup Properties (4250465)

LiteSpeed for SQL Server Version 8.9.5.222 (64bit) Copyright 2020 Quest Software Inc. ... ALL RIGHTS RESERVED. ... The backup file is not encrypted. ... The backup file is not encrypted. ... Header info is empty.

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/4/2024
NA rating | 261 views
Knowledge Article
Exclusive access could not be obtained because the database is in use. RESTORE DATABASE terminated running Automated restored (4250435)

Automated restore fail during execution due DB is in exclusive Access <div>Automated restore is a subset of Steps. ... <div> </div>

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/4/2024
NA rating | 216 views
Knowledge Article
Litespeed for SQL backup files deleted during backups with database in resolving state (4373101)

Backup files were getting deleted when Litespeed tried to append a differential backup to a full backup, in the following environment:<br><br>1. ... There should be an SQL Server for the AG group.

Product(s): LiteSpeed for SQL Server
Last Updated On: 7/4/2024
NA rating | 288 views
Knowledge Article
Error 'Data source name not found and no default driver specified' when running Clean up History task in maintenance plan in SQL 2022 (4375692)

When running a Cleanup History job in a Maintenance Plan, the job doesn&#39;t run and the following error appears:<br><br>&#39;Cleanup Backup,Maintenance plan,LiteSpeed history older than &#39;20231207 13:23:00&#39;<br>Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified<br>Msg 0, Level 0, State 0, Line 0: [Microsoft][ODBC Driver Manager] Connection not open<br>[1] Execution Time: 0 hrs, 0 mins, 1 secs.&#39;<br> Please ensure to download and install a SQL Server Native Client from <a href="https://www.microsoft.com/en-US/download/details.aspx?id=50402?1558859051" target="_blank">here</a> on the machine running the task, as this is required for the History Cleanup to run successfully.

Product(s): LiteSpeed for SQL Server
Last Updated On: 5/13/2024
5 rating | 453 views
Knowledge Article
The DELETE statement conflicted with the REFERENCE constraint "FK_LitespeedActivity_LitespeedDatabase (4374857)

[SQLSTATE 23000] (Error 547) ... The statement has been terminated. ... [SQLSTATE 01000] (Error 3621). ... The step failed. ... A reference value in either of the tables of the LiteSpeed Central database is corrupted and the cleanup process cannot run completely.

Product(s): LiteSpeed for SQL Server
Last Updated On: 2/16/2024
NA rating | 846 views
Knowledge Article
Object Level Restore error - 'Invalid Parameter Detected' when restoring a table (4374528)

Unable to restore a specific table with the Object Level Recovery wizard.

Product(s): LiteSpeed for SQL Server
Last Updated On: 1/16/2024
NA rating | 884 views
Knowledge Article
Amazon AWS S3 'Endpoint' option greyed out in Maintenance Plans and Backup Manager (4374591)

The &#39;Endpoint&#39; field is enabled when the Region in the S3 options is set as Custom.

Product(s): LiteSpeed for SQL Server
Last Updated On: 1/22/2024
NA rating | 839 views
Knowledge Article
Configure LiteSpeed backup with SQL proxy account (4374392)

When security policies restrict access to the backup destination and requirements are not met for SQL Services backup/restore operations fail with error: &quot;Backup of database &quot;Database&quot; failed.

Product(s): LiteSpeed for SQL Server
Last Updated On: 12/20/2023
NA rating | 978 views
Knowledge Article
Is there a way to ensure Transaction Log backups are not overwritten, and contain timestamps within the filename? (4374354)

Is there a way to ensure Transaction Log backups are not overwritten, and contain timestamps within the filename? ... In the Maintenance Plan, select the option &#39;Create unique media&#39; at the time of taking the .TRN backups.

Product(s): LiteSpeed for SQL Server
Last Updated On: 12/15/2023
NA rating | 893 views
Knowledge Article
Restoring a database backup is stuck at 0% (4373825)

When restoring a backup made in Litespeed, from a mapped network drive (e.g. ... Y:\), it hangs at 0% and never completes.<br>There is no job failure in the Litespeed Activity window though, and no errors in the Event Viewer.

Product(s): LiteSpeed for SQL Server
Last Updated On: 11/1/2023
NA rating | 1160 views
Knowledge Article
Unable to find credentials/You must specify AccessKey and SecretKey to connect to Amazon S3 (4373890)

When working with an IAM Role authenticated EC2 Instance and <strong>IMDSv2</strong> set<strong> </strong>to <strong>Required</strong>:<br> ... <p style="text-align: center;"><strong><img src="https://prod-support-images-cfm.s3.amazonaws.com/KB_kA06R000000HLYbSAO_003.png"></img></strong></p>

Product(s): LiteSpeed for SQL Server
Last Updated On: 11/7/2023
NA rating | 937 views
Knowledge Article
Search All Products
Recommended Content
Updating results
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Technical Support
View All