LiteSpeed for SQL Server 8.9.8 - 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.

NOTES:

• 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

Verify Backups

View Information about Backups

Clean Up Old Backups

Restore Backups and Files

Recover Objects from Backups

Encrypt Passwords

TSM-Specific Tasks

Check Progress and Memory

LiteSpeed Information