Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

LiteSpeed for SQL Server 8.9.7 - User Guide

Table of Contents

About Backing Up/Restoring with LiteSpeed

About Backing Up/Restoring Databases

LiteSpeed User Interface Configure LiteSpeed for First Use

Register Repositories

Select a Central Repository

Register and Group Server Instances

Register Servers Create Server Groups Assign Servers to Server Groups About Categorizing Servers Change Server Grouping Methods Create Categories Assign Servers and Databases to Categories

Configure [[[Undefined variable Primary.Product_Name]]] Defaults

Processor Affinity

Configure LiteSpeed Options

General Options Backup Manager Options Log Shipping Options Configure Job Manager Options Set Log Reader Options

Configure Replication and Retention Options for Repositories

Push Statistics to Central Repository Purge Repository Data

LiteSpeed_DeleteActivity

Synchronize Repository Data

LiteSpeed_SyncActivity_Stats LiteSpeed_SyncJobs_Stats

About the Cloud Using the Cloud Cloud Account Settings Cloud Automatic Striping

Back Up Databases

Create and Deploy Backup Templates

Use the Backup Template Wizard Use the Deployment Wizard

Back Up Using the Backup Wizard Back Up Multiple Databases

Logic for Backing Up Multiple Databases Use Wildcard and Regular Expressions in LiteSpeed Multi-Database Backup Wizard

Fast Compression Compression Levels Encryption Double-Click Restore Executables Network Resilience SmartCleanup Accepted Variables

Automate Maintenance Tasks

About Creating Maintenance Plans Back Up Databases Clean Up Maintenance Data Copy Maintenance Plans Automate Similar Backup Tasks on Multiple Instances

Restore Databases

Restore Double-Click Restore Executables Manually Restore a Master Database

Restore Objects

Restore Tables in [[[Undefined variable Primary.product_UI]]] Console Object Level Restores from TSM Backups Execute SELECT Statements Supported SELECT Statements

View Activity and History

View Activity and History

Use Command-Line Interface

LiteSpeed Command Line Arguments Fast Compression Command-Line Agruments SmartCleanup Command-Line Arguments Script Maintenance Plans Tasks Recast Litespeed Backups Convert [[[Undefined variable Primary.product_Name]]] Backups to SQL Server Backups Restore Objects with the Command-Line Interface LicenseInfoCmd Utility

Use Extended Stored Procedures

About Using Extended Stored Procedures Backup examples - extended stored procedures xp_backup_database xp_backup_log xp_delete_tsmfile xp_encrypt_backup_key xp_encrypt_restore_key xp_extractor xp_memory_size xp_objectrecovery xp_objectrecovery_createscript xp_objectrecovery_executeselect xp_objectrecovery_viewcontents xp_restore_attachedfilesonly xp_restore_automated xp_restore_checkpassword xp_restore_checksumonly xp_restore_database xp_restore_filelistonly xp_restore_headeronly xp_restore_setinfo xp_restore_log xp_restore_verifyonly xp_slsCreateDCR xp_slsFastCompression xp_slsReadProgress xp_slsSmartCleanup xp_slssqlmaint xp_sqllitespeed_licenseinfo xp_sqllitespeed_version xp_view_tsmcontents xp_view_tsmmc

Troubleshoot LiteSpeed

Troubleshoot LiteSpeed Activity Troubleshoot Maintenance Plans

Upgrade LiteSpeed Maintenance Plans

Troubleshoot Performance-Related Issues Troubleshoot Previous Versions of LiteSpeed Configure LiteSpeed Logging

Reporting and Logging

Create Support Bundles

Review Additional Resources

Video Tutorials Additional Resources

Upgrade Repositories

LiteSpeed automatically upgrades LiteSpeed repositories during local and remote install.

If you have a LiteSpeed central repository that needs to communicate with a repository for a previous version of LiteSpeed, do one of the following:

Upgrade the statistic agent that transfers information between them on the outdated server instance. To do this, run the Remote Deploy Configuration wizard and select Statistics Agent Only on the Installer Path page. For more information, see Install LiteSpeed on Remote Server Instances.
Upgrade both the server where the LiteSpeedLocal and LiteSpeedCentral to the same version of LiteSpeed.
Rename the LiteSpeedLocal and LiteSpeedCentral databases and recreate them by running the Instance Configuration wizard.

Related Topic

Configure Server Instances

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center