Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

LiteSpeed for SQL Server 8.9 - 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

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

Manage Jobs

Job Manager helps you manage the load on your system and avoid having too many jobs running at the same time. It also improves the efficiency of your system. You can create, alter, or delete SQL Server jobs or Windows tasks. You can quickly reschedule a job/task by dragging it to a different time, day, week, or month.

You can view or schedule jobs/tasks using the following tabs:

SQL Server Jobs/Windows Tasks List—Displays a list of jobs/tasks for each selected instance. For more information, see View Jobs/Tasks in Lists.

Calendar—Displays jobs/tasks according to their schedules and execution history. For more information, see View Jobs/Tasks in Calendars.

Related Topics

Schedule Windows Tasks

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center