Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.5 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

Object Level Recovery Options

To set Object Level Recovery options

  1. Click the Application Button and select Options (Keyboard: ALT+F+O).

  2. Select the Object Level Recovery tab. Review the following for additional information:

    Use this option...

    To...

    Default

    Generate script for tables include

    Instructs LiteSpeed to script or recover one or more of the following:

    • Constraints except foreign keys
    • Triggers
    • Foreign Keys
    • Statistics
    • Indexes

    All are selected

    Bypass tail log processing

    In scenarios when you do not require any transaction log backups and the tail log, you can select to bypass tail log processing. Object Level Recovery operations may work much faster in this case.

    Not selected

    Use table, constraint and index name prefix

    For tables, you can include constraints and index name prefixes in the script by selecting this option and entering the prefix value into the field.

    Not selected
    Use table, constraint and index name suffix For tables, you can include constraints and index name suffixes in the script by selecting this option and entering the suffix value into the field. Not selected
Related Documents