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:
LiteSpeed arguments are flexible and usually do not have any hard coded length limits. Review the following for additional information:
If you want to... | Use... |
---|---|
Back up a database (full, differential, file, or filegroup) |
|
Back up a transaction log |
|
Back up |
|
Backup databases and perform other maintenance tasks | xp_slssqlmaint |
Convert a backup to a Double Click Restore | xp_slsCreateDCR |
If you want to... | Use... |
---|---|
Verify the backup without restoring it |
|
Validate that a file has not been corrupted |
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 |
If you want to... | Use... |
---|---|
Delete old backups | xp_slsSmartCleanup |
If you want to... | Use... |
---|---|
Restore a database |
|
Restore transaction logs |
|
Automate restore operations | xp_restore_automated |
Restore only files attached to a backup |
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) |
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 |
If you want to... | Use... |
---|---|
Delete an object from a specified TSM location |
|
Retrieve TSM-specific information |
|
See available TSM management classes |
If you want to... | Use... |
---|---|
Check the progress of an activity |
|
Check available memory |
If you want to... | Use... |
---|---|
Manage licensing information | xp_sqllitespeed_licenseinfo |
View LiteSpeed components version | xp_sqllitespeed_version |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center