LiteSpeed only supports a small subset of the possible T-SQL SELECT statements. In addition, it does not support computed columns and OUTER JOIN.
LiteSpeed supports the following syntax to execute SELECT statements against a backup file:
SELECT
[ TOP <expression> ]
<select_list>
FROM <select_source>
[ WHERE <search_condition> ]
[ <offset_fetch> ]
<select_list> ::=
<select_item>
| <select_list> , <select_item>
<select_item> ::=
column
| column_wild
| column alias
| alias = column
<select_source> ::=
<table_source>
| <select_source> , <table_source>
| <select_source> JOIN <table_source> ON <search_condition>
| <select_source> INNER JOIN <table_source> ON <search_condition>
<table_source> ::=
table
| table alias
| table AS alias
<search_condition> ::=
{ [ NOT ] <predicate> | ( <search_condition> ) }
[ { AND | OR } [ NOT ] { <predicate> | ( <search_condition> ) } ][,...n]
<predicate> ::=
<expression> { = | > | < | >= | <= | <> | !< | != | !> } <expression>
| expression [ NOT ] LIKE string_constant [ ESCAPE 'escape_char' ]
| expression [ NOT ] BETWEEN expression AND expression
| expression [ NOT ] IN (expression [,...n])
| expression IS [ NOT ] NULL
<expression> ::=
constant
| column
<offset_fetch> ::=
{ OFFSET { integer_constant | offset_row_count_expression } { ROW | ROWS }
[ FETCH { FIRST | NEXT } {integer_constant | fetch_row_count_expression } { ROW | ROWS } ONLY ] }
SELECT * FROM LiteSpeedActivity OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY
SELECT TOP 10 * FROM LiteSpeedActivity WHERE DatabaseID = 6
The LiteSpeed UI Console provides information about your backup processes in the Backup Manager tabs. Depending on what tree level and tab you select, you can view statistics on processes that fail or succeed, the amount of disk space you save, a list of all of the jobs for a server instance or database, and additional information.
You can view the backup activity and history by selecting the Backup Manager Server Tools Ribbon. Information about a category, subcategory, database, server instance, server group, or all of your server instances by selecting the appropriate level in the tree.
Further list, backup template, backup history, and backup analyzer information is provided in the following table.
Tab Name |
Available Level |
Description |
---|---|---|
List |
Server group |
Lists the instances in the server group with their display name, authentication method, SQL Server version, LiteSpeed version, and number of databases. |
Backup Templates | All |
Displays the LiteSpeed Backup templates stored in the central repository. For more information, see Create Backup Templates. In the Backup Templates tab, you can create, edit, clone, import, export and deploy templates, view the template contents, deployment details and modification history. NOTES:
|
Backup History |
Database |
Lists all backups with their date and destination, including native SQL Server backups performed through LiteSpeed. The list also includes backups that have been replaced. You can view information about different dates by changing the Period field or select the dates from a calendar. |
Backup Analyzer |
Database |
Analyzes different settings, such as compression level, striping, and backup destinations, to determine which settings have the best compression and duration values. For more information, see Test Optimal Backup Settings. |
You can group server instances in the navigation pane tree based on their category or server group. Categories are similar to server groups, but they offer different features. For more information, see Change Server Instance Grouping Methods.
Tip: For panes that have grids, you can sort, group, move, and remove the columns:
|
You can view information about the current state of existing maintenance plans and their execution history (CTRL+4).
Select a group, instance, or maintenance plan in the tree view to display the following tabs:
Tab |
Description |
---|---|
Overview |
You can view information about different dates by changing the Period field or clicking |
Maintenance Plans |
Lists all maintenance plans for the server instance. |
History |
Displays execution history of the maintenance plans for the server instance. NOTE: To view execution history of every task in a subplan, configure extended logging. Reporting and Logging in Maintenance Plans |
Design |
Create and edit maintenance plans. |
NOTE: If you receive a message that the server does not exist or access is denied, make sure the instance is registered and connected.
LiteSpeed allows you to perform various tasks directly from the command-line interface (CLI).
NOTES:
To perform tasks using the CLI
Change the directory until you are in the directory containing the LiteSpeed command-line utility (Usually, C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine).
Run a LiteSpeed utility with appropriate arguments.
Use... | If you want to... |
---|---|
SQLLiteSpeed | Perform backup/restore tasks. For more information, see LiteSpeed Command-Line Arguments. |
SLSFastCompression | Back up a database using Fast Compression technology. For more information, see Fast Compression Command-Line Arguments. |
SLSSmartCleanup | Delete old backups. For more information, see SmartCleanup Command-Line Arguments. |
SLSRecast | Change backup options for the existing LiteSpeed backups. For more information, see Recast LiteSpeed Backups. |
Extractor | Convert LiteSpeed backups to the native SQL Server backups. For more information, see Convert LiteSpeed Backups to SQL Server Backups. |
OLR | Restore database objects. Restore Objects with the Command-Line Interface |
SLSSQLMaint | Perform various database maintenance tasks. For more information, see Script Maintenance Plans Tasks. |
LicenseInfoCmd | View currently installed license or to register a new key. For more information, see LicenseInfoCmd Utility. |
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy