LiteSpeed for SQL Server 8.9.7 - User Guide

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.

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:

• encrypt (For more information, see Encryption Methods.)
• compress (For more information, see Compression Methods.)
• mirror
• stripe
• attach files
• log activity
• and more...

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

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

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

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.

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.

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.

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 databases and attached files immediately or schedule a restore job. For more information, see Restore Databases Using the Restore Wizard.

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.

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).

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.

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

Display and edit the LiteSpeed license key information.

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

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.

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.

Run the Backup Wizard.

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

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

Run the Create LiteSpeed Log Shipping Plan Wizard.

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

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.

Run the Job Manager and displays the Job Manager Ribbon.

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

Refreshes the selected items.

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.

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.

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.

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

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.

View the list of servers grouped by instances.

View the list of servers grouped by category.

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

View instances in the navigation pane by an alphabetic sort.

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.

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.

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

LiteSpeed Help.

Run the Backup Wizard for several databases.

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

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

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

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

Displays the general properties of the current server.

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

Run the Backup Wizard.

Display analyzer graph of backup jobs.

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

Display a listing of recent SQL Server transactions.

Display general LiteSpeed properties.

Select a server in the SQL Server Jobs pane.

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

Display jobs for a particular day.

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

End checking log changes.

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

Run the Recover Table Wizard to recover dropped tables.

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

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.

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

Search and locate log entries.

Displays a preview of currently selected log.

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

Run the Create Log Shipping Plan Wizard.

Run the Backup Wizard for several databases.

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

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

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

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

Displays the general properties of the current server.

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

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 a selected object.

Select scripted objects.

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.

Search for a specified database object.

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

• Install stored procedures and extended stored procedures
• Create databases, tables, and indexes
• Insert, update, and delete to/from the MSDB, LiteSpeedLocal and LiteSpeedCentral databases

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.

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.

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.

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

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