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

Create Support Bundles

If you have not found an answer to your question, you can create a support bundle and send it to customer support. The support bundle contains information about your database, system configuration, and settings and can help troubleshoot problems.

To create a LiteSpeed UI Console support bundle

Select Application button | Help | Support Bundle.

To create a server support bundle

Right-click a server in the tree and select Support | LiteSpeed Core Details.
Send the support bundle to Quest Software customer support or click Clipboard to save the generated content to file.

Related Topics

Configure Logging in LiteSpeed

Review Additional Resources

Get the latest product information, find helpful resources, and join a discussion with the LiteSpeed team and other community members. Join the LiteSpeed community at: https://www.quest.com/community/products/litespeed/.

Use this site to:

Share your knowledge
Participate in forums
Learn about new features and enhancements in Quest products
Download the latest product releases
Find expert tips and tricks
Communicate with product teams
Participate in beta programs

Video Tutorials

If you want to learn more about using LiteSpeed for SQL Server, check out: https://support.quest.com/litespeed-for-sql-server/videos.

Additional Resources

Share and find information about Quest Software products and SQL Server related technologies at:

ToadWorld	http://www.toadworld.com/platforms/sql-server/default.aspx
Microsoft SQL Server World Wide Users Group	http://www.sswug.org
Microsoft Product Support	http://support.microsoft.com
Microsoft Developer Network (MSDN)	http://msdn.microsoft.com
Professional Association for SQL Server	http://www.sqlpass.org
Microsoft SQL Server Developer Center	http://msdn.microsoft.com/en-us/sqlserver
TechNet Site	http://technet.microsoft.com
Microsoft SQL Server Web Site	http://www.microsoft.com/sql
IBM Spectrum Protect™ (Tivoli Storage Manager - TSM) Information Center	http://publib.boulder.ibm.com/infocenter/tsminfo/v6r3/index.jsp

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