LiteSpeed for SQL Server 8.9.8 - Configure Log Shipping 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

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem