LiteSpeed for SQL Server 8.9.5 - Installation Guide

About Restoring Objects

LiteSpeed helps you restore specific objects from a native or LiteSpeed backup file stored locally or in Cloud storage. You can:

• View backup contents and preview table data.
• Query backups. For more information, see Execute SELECT Statements.
• Restore objects from the backup files.

NOTE: Object Level Recovery is only available with the Enterprise license.

You can also restore objects in the command-line or using extended stored procedures. See the following for more information:

• Restore Objects with the Command-Line Interface
• Recover Objects from Backups using the extended stored procedures

It is not recommended to use Object Level Recovery to recover tables with the size equal to or more than 1TB. It is recommended to use Object Level Recovery to recover tables with a size larger than 100GB on high-performance systems only. In other cases, a full database restore operation is preferred.

Related Topics

Restore Objects in the LiteSpeed UI Console

Execute SELECT Statements