LiteSpeed for SQL Server 8.9 - Configure Log Shipping 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).