Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.5 - Installation Guide

About Using Extended Stored Procedures

You can use extended stored procedures to perform LiteSpeed activities without using the LiteSpeed UI Console.

When you install LiteSpeed, the installer registers the LiteSpeed extended stored procedures with every instance of SQL Server selected at installation. These extended stored procedures contain a series of commands that you can execute in SQL Query Analyzer or other SQL scripting tool, such as Toad for SQL Server.


  • You can only run LiteSpeed commands on SQL Servers on which the LiteSpeed stored procedures have been registered.
  • Extended stored procedures are executed against the master database.
  • Review the Syntax sections to see which arguments are mandatory, which are optional, and which are mutually exclusive. Mutually exclusive arguments are separated by a vertical bar. Optional arguments are enclosed in square brackets. Round brackets are used to group arguments.
  • Review the Arguments sections for more information about the arguments and accepted values.
  • LiteSpeed arguments are flexible and usually do not have any hard coded length limits. Review the following for additional information:

    • Path type parameters are the MAX_PATH for any filesystem being employed.
    • Backup name, database name, etc. are passed into SQL Server and have the same requirements.
    • TSM has a limit on object names.
    • Other than that, you are only limited by OS.

Create Backups

If you want to... Use...

Back up a database (full, differential, file, or filegroup)


Back up a transaction log


Back up a database using Fast Compression


Backup databases and perform other maintenance tasks xp_slssqlmaint
Convert a backup to a Double Click Restore xp_slsCreateDCR

Verify Backups

If you want to... Use...

Verify the backup without restoring it


Validate that a file has not been corrupted


View Information about Backups

If you want to... Use...

List header information for all LiteSpeed backups on a backup device


View information about a stripe set


List the logical file names in a backup


Check a password against a backup xp_restore_checkpassword

Clean Up Old Backups

If you want to... Use...
Delete old backups xp_slsSmartCleanup

Restore Backups and Files

If you want to... Use...

Restore a database


Restore transaction logs


Automate restore operations xp_restore_automated

Restore only files attached to a backup


Recover Objects from Backups

If you want to... Use...
Restore tables from backups xp_objectrecovery

List restorable objects in a backup


Create DDL scripts to recover objects


Execute a SELECT statement against the backup (can be used for row-level restores)


Encrypt Passwords

If you want to... Use...
Check a password against a backup xp_restore_checkpassword
Encrypt a password for backup xp_encrypt_backup_key
Encrypt a password for restore xp_encrypt_restore_key

TSM-Specific Tasks

If you want to... Use...

Delete an object from a specified TSM location


Retrieve TSM-specific information


See available TSM management classes


Check Progress and Memory

If you want to... Use...

Check the progress of an activity


Check available memory


LiteSpeed Information

If you want to... Use...
Manage licensing information xp_sqllitespeed_licenseinfo
View LiteSpeed components version xp_sqllitespeed_version


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating