LiteSpeed for SQL Server 8.9.7 - Installation Guide

Introduction

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.

LiteSpeed Architecture

The diagram below shows how the LiteSpeed components communicate to SQL Server to create a backup and how data gets into the local repository and then is pushed to the central repository.

LiteSpeed Components

LiteSpeed UI Console

The LiteSpeed UI Console is a graphical user interface that maintains the accessibility of LiteSpeed functionality. You need to install at least one LiteSpeed UI Console on the computer from which you want to manage your SQL Servers and control backup and restore processes.

LiteSpeed Server Components

The core of LiteSpeed includes the LiteSpeed extended stored procedures, compression and encryption engines and other components that provide command-line access to the product's functionality and support the LiteSpeed UI Console.

You need to install LiteSpeed core components on all server instances where you want to benefit from LiteSpeed's fast and flexible backup and recovery solutions.

NOTE: If you do not install LiteSpeed core components on the server instances, you can only conduct native SQL Server backups.

Local and Central Repositories

LiteSpeed repositories collect and retain statistics on backup activity that occurs through LiteSpeed, including backups conducted from the LiteSpeed UI Console, command-line, or using the extended stored procedures. Repositories collect and present statistics for registered servers. They are not a list of servers. If a server goes offline you can use the central repository to find out information about it, such as the last time LiteSpeed backed up the server.

LiteSpeed installs statistics databases through the Instance Configuration wizard. For more information, see Configure Server Instances. LiteSpeed installs a local repository for each server instance you select. Then, you create and select a central repository to gather the local repositories' statistics. LiteSpeed uses the LiteSpeed Activity Service to transfer the statistics from each local repository to the central repository, so that the central repository provides a complete picture of backups on all servers.

With the repositories, you can see backups that have failed or succeeded in the Backup Manager Overview tab. LiteSpeed displays the statistics for the server group, category, server, or database that you select in the navigation pane tree.

Multiple Central Repositories

LiteSpeed allows you to have multiple central repositories. For example, you may want to have one set of server instances report to one central repository and another set to a second central repository. However, one local repository cannot report to two central repositories.

If you want to use multiple central repositories, register each central repository, and then select the appropriate central repository. For more information, see Register Central Repositories.

Related Topics

Register Central Repositories

Select a Central Repository

Push Statistics to Central Repository

Upgrade Repositories