Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.7 - Integration with TSM 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

If you want to... Use...

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

xp_backup_database

Back up a transaction log

xp_backup_log

Back up a database using Fast Compression

xp_slsFastCompression

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

xp_restore_verifyonly

Validate that a file has not been corrupted

xp_restore_checksumonly

View Information about Backups

If you want to... Use...

List header information for all LiteSpeed backups on a backup device

xp_restore_headeronly

View information about a stripe set

xp_restore_setinfo

List the logical file names in a backup

xp_restore_filelistonly

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

xp_restore_database

Restore transaction logs

xp_restore_log

Automate restore operations xp_restore_automated

Restore only files attached to a backup

xp_restore_attachedfilesonly

Recover Objects from Backups

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

List restorable objects in a backup

xp_objectrecovery_viewcontents

Create DDL scripts to recover objects

xp_objectrecovery_createscript

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

xp_objectrecovery_executeselect

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

xp_delete_tsmfile

Retrieve TSM-specific information

xp_view_tsmcontents

See available TSM management classes

xp_view_tsmmc

Check Progress and Memory

If you want to... Use...

Check the progress of an activity

xp_slsreadprogress

Check available memory

xp_memory_size

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