Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.7 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

About Backing Up/Restoring with LiteSpeed

LiteSpeed® for SQL Server®, or LiteSpeed, is a fast and flexible backup and recovery solution that allows database administrators to easily maintain complete control over the backup and recovery process. LiteSpeed's low-impact, high-performance compression and encryption technology helps reduce storage costs and protect data, while maintaining a high level of recoverability.

About Backing Up/Restoring Databases

LiteSpeed has the following key features:

Use this feature... To...
Backup Analyzer

Evaluate different backup options, 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.

Backup Wizard

Back up individual databases. This option lets you define backup options individually for each database. You can create native SQL Server or LiteSpeed backups, generate backup scripts, run backups immediately or schedule SQL Agent jobs. LiteSpeed supports the following options for backups:

Be sure to select Use LiteSpeed to leverage many LiteSpeed advanced features. For more information, see Back Up Databases.

Multi-Database Backup Wizard

Back up several databases with the same options. For more information, see Multi-Database Backup.

Backup Templates

Automate backing up databases on multiple server instances by deploying a LiteSpeed Backup Template. For more information, see Create Backup Templates.

Maintenance Plans

Automate backing up databases. Maintenance Plans provide flexible backup options as well as additional database maintenance options, such as CleanUp and Rebuild Indexes tasks. For more information, see About Automating Maintenance Tasks.

Fast Compression

Reduce backup size and decrease backup times from hours to minutes by including differential backups in the nightly backup routine. For more information, see Fast Compression.

Double Click Restore Restore Double Click Restore executable files on a server instance that does not have LiteSpeed installed. For more information, see Double Click Restore Executables.
Network Resilience

Control network resilience options. LiteSpeed's read and write resilience can handle various failures on both network and attached storage devices. For more information, see Network Resilience.

Adaptive Compression

Let LiteSpeed select optimal compression based on server performance at the time of backup. Adaptive Compression can optimize backups either for speed or for small size. For more information, see Compression Methods.

Restore Wizard

Restore databases and attached files immediately or schedule a restore job. For more information, see Restore Databases Using the Restore Wizard.

Automated Restore

Automate restoring the most recent database backups. If backing up to unique filenames, you only need to specify a folder where LiteSpeed will look for candidates for restore. For more information, see Restore Databases Using the Restore Wizard.

Object Level Recovery

List, query, preview and restore specific objects directly from the native SQL Server or LiteSpeed backup files. For more information, see About Restoring Objects (Object Level Recovery).

Log Shipping

Automate backing up and restoring database transaction logs on one or more standby databases. See the Configure Log Shipping guide for more information.

You can back up and restore with LiteSpeed using wizards in the LiteSpeed UI Console, extended stored procedures and the command-line interface.

Use the LiteSpeed UI Console to view activity and history for your backups, including 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. For more information, see View Backup Manager Activity and History.

 

LiteSpeed User Interface

Use the LiteSpeed user interface (called the LiteSpeed UI Console) to create backups, restore databases, recover database objects, view activity and history for your backups, design Maintenance Plans, schedule SQL Agent jobs and monitor tasks progress.

The LiteSpeed UI Console has the following components:

Application Menu

The Application menu displays often used LiteSpeed features and replaces the previous File menu.ClosedClick here to see the Application menu.

Use the Application menu to access the following features:

Feature Description

Repository Registration

Display and edit repository registration. You can add repository, edit connection, delete connection, test connection, import, and export repositories. For steps on repository registration, refer to Register Central Repositories.

Cloud Accounts

Display and edit registered cloud account settings. You can add, edit, delete, import, and export cloud accounts.

Deploy

Run the Remote Deploy Configuration wizard. Use this wizard to deploy the LiteSpeed core components and edit LiteSpeed the configuration to remote servers.

License

Display and edit the LiteSpeed license key information.

Help

Display the LiteSpeedSupport information. Displays the LiteSpeed Help, LiteSpeed Community, Support Bundle, and About information. The File ribbon defaults to the Help selection.

Options

Display and edit the following LiteSpeed options: General, Backup Manager Options), Log Shipping Options, Job Manager Options, Log Reader Options, and Object Level Recovery options.

Exit

Exit the LiteSpeed product.

Home Ribbon

The Home ribbon displays often used features. ClosedClick here to see the Home ribbon.

Use the Home ribbon to access the following features:

Feature Description

SQL Server Registration

Register new SQL Servers and groups. You can also delete and edit existing ones. You can also manage licenses and edit credential information for each registered SQL Server instance. See License Registration.

Backup

Run the Backup Wizard.

Multi-Database Backup

Run the Backup Wizard for several databases.

Restore

Run the Restore Wizard. You can also restores databases, files and file groups, transaction logs, and attached files.

Automated Restore

Run the Restore Wizard with Automated Restore as the default selection.

Log Shipping

Run the Create LiteSpeed Log Shipping Plan Wizard.

Backup Templates

Run the Create New Backup Template Wizard. You can also create new, edit, deploy or remove existing backup templates.

Maintenance Plans

Create a new maintenance plan by default. You can also create new maintenance plan, paste maintenance plan, import maintenance plan, and upgrade LiteSpeed maintenance plans.

Display Jobs

Run the Job Manager and displays the Job Manager Ribbon.

Read Transaction Log

Run the Read Log Wizard and displays the Log Reader Ribbon.

Smart Cleanup Policies Run Smart Cleanup Policies editor.

Refresh

Refreshes the selected items.

Load databases Initialize loading databases for all SQL Servers that are registered. NOTE: This action may be time consuming depending on the number of SQL Servers

View Ribbon

The View ribbon displays often used view features. ClosedClick here to see the View ribbon.

Use the View Ribbon to access the following features:

Feature Description

Backup Manager

Manage LiteSpeed and native SQL Server backups and restores with a variety of advanced tools. You can also view detailed information about your backup and restore processes, including statistics on processes that fail or succeed, the amount of disk space you save, and a list of all of the jobs for a server instance or database.

Log Shipping

Automate backing up a database (the publisher) and restoring its transaction logs on one or more standby databases (the subscribers). The process runs automatically throughout the day at the interval you specify, which creates synchronized databases.

Object Level Recovery

Read native SQL Server or LiteSpeed backups to view tables, query backup data and restore tables, schemas, and views. You can also generate DDL scripts for one or more databases objects.

NOTE: Object Level Recovery is only available with the Enterprise license.

Maintenance Plans

Create a new maintenance plan by default. Several other items are available. Automate routine database maintenance tasks, such as backing up databases, updating statistics, and rebuilding indexes to run on a specific day and time.

Job Manager

Schedule, monitor, and manage SQL Agent jobs and Windows tasks.

Log Reader

Restore data in transaction log files by rolling back any operation and reconstructing transactions. You can view recent transactions, the full database log, and all transactions in the backup file.

Server Group

View the list of servers grouped by instances.

Categories

View the list of servers grouped by category.

Custom

View instances in the navigation pane by a defined custom sort.

Alphabetically

View instances in the navigation pane by an alphabetic sort.

Local

View list of local instances in the navigation pane. The local server instance icon is displayed in the navigation pane.

Note: The local repository instance icon (and central) are displayed in the View ribbon when a central repository is selected. When a central repository is not used, both the local and central icons are not visible in the View ribbon.

Central

View list of central instances in the navigation pane. The central server instance icon is displayed in the navigation pane.

Note: The central repository instance icon (and local) are displayed in the View ribbon when a central repository is selected. When a central repository is not used, both the local and central icons are not visible in the View ribbon.

Category

Select the server category grouping based on location or role, assign categories, and edit categories.

Background Tasks

Display running background tasks.

Help Ribbon

The Help ribbon displays often used view features. ClosedClick here to see the Help ribbon.

Use the Help Ribbon to access the following features:

Feature Description

LiteSpeed Help

LiteSpeed Help.

LiteSpeed Community LiteSpeed Community link.
Support Bundle LiteSpeed Support Bundle. Use it if the support team ask.
About LiteSpeed About information.

Backup Manager Server Tools Ribbon

The Backup Manager Server Tools ribbon is displayed when you select a SQL Server from the Navigation Pane. ClosedClick here to see the Backup Manager Server Tools ribbon.

Use the Backup Manager Server Tools ribbon to access the following features:

Feature Description

Backup

Run the Backup Wizard.

Multi-Database Backup

Run the Backup Wizard for several databases.

Restore

Run the Restore Wizard with database as the default selection. You can also restore files and file groups, transaction logs, and attached files.

Automated Restore

Run the Restore Wizard with Automated Restore as the default selection.

Log Shipping

View the LiteSpeed Log Shipping information in the navigation pane.

Backup Templates

Runs the Create New Backup Template Wizard. You can also create new, edit, deploy, and remove templates.

Maintenance Plans

Create a new maintenance plan by default. Several other items are available. Automate routine database maintenance tasks, such as backing up databases, updating statistics, and rebuilding indexes to run on a specific day and time.

Display Jobs

View the Job Manager and list of jobs in various states. Makes visible the Job Manager ribbon.

Read Transaction Log

Run the Read Log Wizard and LiteSpeed displays the Log Reader Ribbon.

Properties

Displays the general properties of the current server.

LiteSpeed Defaults

Displays the LiteSpeed backup default options. Refer to Configure LiteSpeed Defaults.

Refresh

Refreshes the selected item.

Database Tools Ribbon

The Database Tools ribbon is displayed when you select Backup Manager from the View Ribbon. ClosedClick here to see the Database Tools ribbon.

Use the Database Tools ribbon to access the following features:

Feature Description

Backup

Run the Backup Wizard.

Multi-Database Backup

Run the Backup Wizard for several databases.

Restore

Run the Restore Wizard. You can also restores databases, files and file groups, transaction, and attached files.

Automated Restore

Run the Restore Wizard with Automated Restore as the default selection.

Backup Analyzer

Display analyzer graph of backup jobs.

Display Jobs

Display jobs and tasks according to their schedules and execution history.

Read Transaction Log

Display a listing of recent SQL Server transactions.

Properties

Display general LiteSpeed properties.

Refresh

Refresh the database items.

Job Manager Ribbon

The Job Manager ribbon is displayed when you select Job Manager from the View Ribbon. ClosedClick here to see the Job Manager ribbon.

Use the Job Manager ribbon to access the following features:

Feature Description

SQL Server Jobs

Select a server in the SQL Server Jobs pane.

Windows Tasks

When selected the Task Scheduler displays the Task Scheduler 1.0 pane and the Task Scheduler 2.0 pane. The panes display two distinct separate task schedules that can be alternately viewed.

LiteSpeed automatically detects the version of Windows Tasks. The Task Scheduler 2.0 includes support for Task Scheduler 1.0 tasks.

Select a server in the Windows Tasks pane

Day

Display jobs for a particular day.

Work Week

Display jobs for a particular work week.

Week

Display jobs for a particular week.

Month

Display jobs for a particular month.

Options

Select the options for Job Manager. (See Job Manager Options.)

Refresh

Refreshes the Job Manager items.

Log Reader Ribbon

The Log Reader ribbon is displayed when you select Log Reader from the View Ribbon. ClosedClick here to see the Log Reader ribbon.

Use the Log Reader ribbon to access the following features:

Feature Description

Read Log

Run the Read Log Wizard to generate a job transaction log.

Start checking

Begin checking log changes.

Stop checking

End checking log changes.

Undo / Redo Wizard

Run the Undo / Redo Wizard to generate a T-SQL script. that reverses changes previously made or reapplies current changes.

Recover Table Wizard

Run the Recover Table Wizard to recover dropped tables.

Table History Wizard

Run the Table History Wizard to view changes made to specific tables.

Filter

Filter the log entries by general, objects, operations, logins, users, hosts, and applications. When selected the Filter option remains highlighted in the log reader ribbon.

Grouping

Group the log entries by column headers. When selected the Grouping option remains highlighted in the log reader ribbon.

Find

Search and locate log entries.

Print Preview

Displays a preview of currently selected log.

Export to CSV

Export table to a CSV file. Other export options include: HTML, XML, and DB.

Refresh

Refreshes the Log Reader items.

Log Shipping Server Tools Ribbon

The Log Shipping Server Tools ribbon is displayed when you select Maintenance Plans from the View Ribbon. ClosedClick here to see the Log Shipping Server Tools ribbon.

Use the Log Shipping Server Tools ribbon to access the following features:

Feature Description

New Plan

Run the Create Log Shipping Plan Wizard.

Backup

Run the Backup Wizard.

Multi-Database Backup

Run the Backup Wizard for several databases.

Restore

Run the Restore Wizard with database as the default selection. You can also restore files and file groups, transaction logs, and attached files.

Automated Restore

Run the Restore Wizard with Automated Restore as the default selection.

Log Shipping

View the LiteSpeed Log Shipping information in the navigation pane.

Backup Templates

Runs the Create New Backup Template Wizard. You can also create new, edit, deploy, and remove templates.

Maintenance Plans

Create a new maintenance plan by default. Several other items are available. Automate routine database maintenance tasks, such as backing up databases, updating statistics, and rebuilding indexes to run on a specific day and time.

Display Jobs

View the Job Manager and list of jobs in various states. Makes visible the Job Manager ribbon.

Read Transaction Log

Run the Read Log Wizard and LiteSpeed displays the Log Reader Ribbon.

Properties

Displays the general properties of the current server.

LiteSpeed Defaults

Displays the LiteSpeed backup default options. Refer to Configure LiteSpeed Defaults.

Refresh

Refreshes the selected item.

Object Level Recovery Ribbon

The Object Level Recoveryribbon is displayed when you select Object Level Recovery from the View Ribbon. ClosedClick here to see the Object Level Recovery ribbon.

Use the Object Level Recovery ribbon to access the following features:

Feature Description

Object Level Recovery Wizard

Read native SQL Server or LiteSpeed backups to start working with Object Level Recovery. (version 2: to view database objects, query and restore backup data, generate DDL scripts and more.)

NOTE: Object Level Recovery is only available with the Enterprise license.

Recover Table

Run the Recover Table Wizard.

Recover Schema

Recover a selected object.

Select Scripted

Select scripted objects.

Filters

Apply filters to the database object search. Optional filters include: All, Defaults, Extended Procedures, Functions, Partition Functions, Partition Schemes, Roles, Rules, Stored Procedures, Tables, Memory Optimized Tables, History Tables, Triggers, Types, Users, Views, Views (indexed). and Xml Schema Collection.

Find

Search for a specified database object.

Options

Open the Object Level Recovery options Object Level Recovery options display.

Navigation Pane

The navigation pane has two parts: a list of LiteSpeed features at the bottom and feature-specific information at the top. Once you select a feature, the top of the navigation pane and the central pane update with the relevant information. The top of the navigation pane displays a tree of servers for Backup Manager, Log Shipping, and Maintenance Plans. It displays key tasks and options for the other features. When local servers are selected in the View ribbon, the local instance icon is displayed in the navigation pane. When central servers are selected in the View ribbon, the central instance icon is displayed in the navigation pane.ClosedClick here to see the navigation pane.Search bar for SQL Server Groups, SQL Servers and SQL databases is added under the SQL Server tree in the Backup Manager window. To avoid the manual searching/scrolling of Server Groups, SQL Servers or SQL databases, the search bar is added above the SQL Server tree. It is visible in the Backup manager, Log shipping and Maintenance plans. NOTE: Search is not searching any created Log Shipping or Maintenance Plans. If an item name contains queried phrase it will be listed as a result. Search is case insensitive. Refresh does not affect the input. There is an option button to clear the input.

Tip: Click to change the features that appear as button selectable in the navigation pane.

Use the Navigation pane to access the following features:

Feature Description Keyboard shortcut

Backup Manager

Manage LiteSpeed and native SQL Server backups and restores with a variety of advanced tools. You can also view detailed information about your backup and restore processes, including statistics on processes that fail or succeed, the amount of disk space you save, and a list of all of the jobs for a server instance or database.

CTRL+1

Log Shipping

Automate backing up a database (the publisher) and restoring its transaction logs on one or more standby databases (the subscribers). The process runs automatically throughout the day at the interval you specify, which creates synchronized databases.

CTRL+2

Object Level Recovery

Read native SQL Server or LiteSpeed backups to view tables, query backup data and restore tables, schemas, and views. You can also generate DDL scripts for one or more databases objects.

NOTE: Object Level Recovery is only available with the Enterprise license.

CTRL+3

Maintenance Plans

Create a new maintenance plan by default. Several other items are available. Automate routine database maintenance tasks, such as backing up databases, updating statistics, and rebuilding indexes to run on a specific day and time.

CTRL+4

Job Manager

Schedule, monitor, and manage SQL Agent jobs and Windows tasks.

CTRL+5

Log Reader

Restore data in transaction log files by rolling back any operation and reconstructing transactions. You can view recent transactions, the full database log, and all transactions in the backup file.

CTRL+6

Central Pane

The central pane displays information based upon your selection in the navigation pane (Closedclick here to see an example of the central pane). Each feature has a unique home page and set of tabs. For a description of the Backup Manager tabs and central pane options, see View Backup Manager Activity and History.

Central pane for a server instance selected in the Backup Manager

NOTE: If you selected a central repository, LiteSpeed does not display the home page for Backup Manager, Log Shipping, and Maintenance Plans.

Background Tasks Pane

The Background Tasks pane displays processes that you selected to run in the background while you use the LiteSpeed UI Console. You can dock the pane by clicking Auto Hide or clear a process by clicking. ClosedClick here to see the Background Tasks pane.

To view the pane, select View | Background Tasks.

NOTE: Canceling a background task does not mean that SQL Server is done rolling back the process.

Properties Pane

The Properties pane lists properties about the item selected in the navigation pane.ClosedClick here to see the Properties pane.

To view the properties pane, click the Application Button and select Options and then Display properties in dockable window on the General tab. You can dock the pane by clicking.

Toolbar

The toolbar has the following parts:

Toolbar Part

Description

Navigation

Includes buttons to navigate within the LiteSpeed UI Console, including Minimize the Ribbon, Back, Forward, Home, and Help:

Quick Access Tool Bar

Includes buttons to navigate within the LiteSpeed UI Console, including Start Backup Wizard, Refresh selected item, and Customize Quick Access Toolbar:

Tip: To hide a toolbar, right-click and deselect it.

 

Configure LiteSpeed for First Use

LiteSpeed requires the following privileges and grants:

Account Requirement

User account that performs the LiteSpeed installation

Windows administrator rights and DBA privileges required to
  • Install stored procedures and extended stored procedures
  • Create databases, tables, and indexes
  • Insert, update, and delete to/from the MSDB, LiteSpeedLocal and LiteSpeedCentral databases
User account that runs the LiteSpeed UI Console

Power User privileges (or some equivalent).

NOTE: When executing a Double Click Restore, Windows Vista, Windows Server 2008, and higher require that the Windows user account is an administrator.

SQL Server service account

Sysadmin server role privileges required to

  • Push stats to local repository
  • Back up or restore using extended stored procedures
  • Execute a scheduled job
  • Start a job manually

TIP: The SQL service account needs at least read\write access to the following directory and all its contents:
C:\ProgramData\Quest Software\LiteSpeed\SQL Server\

NOTE: SQL Server Configuration Manager should always be used when changing SQL Server service accounts.

SQL Agent service account (or a proxy account)

Windows or SQL Server accounts specified during instance configuration (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration)

For more information, see Configure Server Instances.

If you select SQL Server authentication, the SQL Server account must have sysadmin server role privileges, while the Activity Manager service account must have the Log on as a service permission.

If you select the Windows authentication method for both the local and central repository, then the Activity Manager service account specified on the Service Account page must have the sysadmin privileges and the Log on as a service permission.

NOTE: If the central repository is located on another server, the LiteSpeed Activity Manager service account must have domain rights for two-way communication between the local and central repositories.

Windows or SQL Server account (Application Button | Repository Registration...)

For more information, see About Collecting Statistics in Repositories.

Db_owner of the central repository (required to retrieve data from the central repository)

Windows or SQL Server account (Application Button | SQL Server Registration...)

Sysadmin server role privileges required to

  • Connect to SQL Server and retrieve SQL Server properties
  • Back up or restore
  • Execute procedures, retrieve MSDB history
  • Access repositories

TSM with LiteSpeed

If using TSM, its recommended that the following line be added to the dsm.opt file used by LiteSpeed.

errorlogname "C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs\dsierror.log"

 

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating