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

Restore Objects

About Restoring Objects (Object Level Recovery)

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

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:

 

Related Topics


Was this topic helpful?

[Select Rating]



Restore Tables in [[[Undefined variable Primary.product_UI]]] Console

Restore Objects in the LiteSpeed UI Console

Before you can recover objects or execute a SELECT statement, you must read the backup file to create an index of restorable objects. The index is an .lsm file. During the backup process the .lsm file is created in the temp directory and attached to the backup file after the backup is completed.

Notes:

  • You can restore objects directly from the Cloud. It is recommended to use this in cases where there is a fast connection between OLR and the Cloud.
  • You cannot restore objects directly from TSM files or tape backups. For more information, see Object Level Restores from TSM Backups.
  • Object Level Recovery does not support SQL Server 2008 Transparent Data Encryption (TDE).
  • LiteSpeed may take a long time to read the backup file for large databases, often with little response in the LiteSpeed UI Console. To prevent this, the Optimize Object Level Recovery speed option on the Backup wizard Options page is selected by default to create the index during the backup.
  • Objects are recovered as they existed at the time they were backed up. You cannot recover data to a random point in time.
  • Direct mode - In scenarios where you want the application to work with SQL Server directly using a TCP/IP connection without involving the SQL Server client, you can enable direct mode which significantly improves deployment and configuration of your applications. You can enable and disable the use of direct mode from the the Recover Table Wizard.
  • 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. You can enable and disable bypass tail log processing from the toolbar, and when running the Object Level Recovery Wizard and the Recover Table Wizard.

To read the backup files

  1. Select the Object Level Recovery pane (CTRL+3).

  2. Select Object Level Recovery Wizard.

  3. On the Welcome page click Next.

  4. On the Specify Recovery Destination page, select the server instance.

  5. On the Specify Backup Source:

    • Select Database to restore from a specific database's backup history.
    • Select Device and Disk to manually select files on disk to restore. Click Add. The Backup File Location window is displayed. You can also click Remove or Content to remove the file or view file contents. Selecting Content displays a window showing file general properties and file backup sets properties.
    • Select Device and Cloud to manually select files from the Cloud to restore.
  6. On the Backup File Location window, locate and select the backup file to read. Once selected, the file path and file name are displayed. Click OK. You can browse the network, add, delete, and rename folders.

  7. On the Select Backup Files page, click Next.

    note: LiteSpeed must be installed on the server instance you select on the Specify Recover Destination page.

  8. On the Backup Content page, select a backup to recover and click Next.

    Bypass tail log processing - Select to bypass tail log processing. Object Level Recovery operations may work faster.

    tip: Only disk backups are supported for OLR.

  9. On the Preview Script page, view the script that will run to retrieve the backup content. Click Next.

  10. Complete the wizard.

Review the Backup File Contents

After you read the backup file, its contents appear in the Overview tab (Closedclick here to see the Overview tab).

The Overview tab has the following panes:

1. Objects Grid

The grid displays all of the restorable objects in backup file. You can filter the objects that appear in the list by selecting the appropriate options in the toolbar.

2. Script Preview

The script preview displays the DDL script. To script an object, right-click it in the objects grid and select Generate DDL Script.

For tables, you can also include constraints, indexes, and triggers in the script by selecting the appropriate options on the Object Level Recovery tab in Object Level Recovery options. You can script more than one object, and scripted objects have a small scroll icon beside them in the objects grid. To view all of the scripts in the script preview, click the Select Scripted button in the Object Level Recovery ribbon menu.

note: You can save, copy, print, and search the script in LiteSpeed, but you cannot edit or execute it in the script preview pane.

3. Table Data Preview

The table data preview displays the contents of the table. To preview a table's data, right-click the table in the objects grid and select Preview Data. You can only preview the data of one table at a time, and the previewed table has a small chart icon beside it in the objects grid. A table that you preview and script has a small chart and scroll icon beside it.

Tip: For panes that have grids, you can sort, group, move, and remove the columns:

  • To sort and group the records, right-click a column header and select the appropriate options.
  • To sort records against multiple columns, click column headers while holding the SHIFT key. For example, to sort by type and then by name, click the Type column header and then SHIFT+click the Name column header.
  • To add or remove columns, right-click a column header and select Column Chooser. Add a column by dragging it from the list into the column headers. Remove a column by dragging its column header into the list.
  • To move a column, drag the column header to the new location.

Restore Tables and Schemas

Restoring a table in the LiteSpeed UI Console restores the table's schema and data.

Tip: CTRL-click objects in the grid to select multiple objects for recovery.

To restore tables

  1. Select a table in the objects grid and click Recover Table.

  2. Complete the wizard. Review the following for additional information:

    Database

    Select the database.

    LiteSpeed will not overwrite an existing table. If you select the same server instance and database as the original table, you must use a different table name.

    Ship directory

    Select the ship directory.

    Enter the path or click to navigate to it.

    This option stores the object at the directory but does not restore it.

    Use table, constraint and index name prefix

    Enter the prefix naming convention in the field provided. Select this option when choosing to use prefix naming conventions with tables, constraints, and index names.

    Use table, constraint and index name suffix

    Enter the suffix naming convention in the field provided. Select this option when choosing to use suffix naming conventions with tables, constraints, and index names.

    Bulk insert

    Select this option to import data into a table using BCP for data recovery. It requires to use a temporary directory for temporary files.

    The temporary directory is a Windows temp folder by default or you can specify your custom directory.

    Temporary directory:

    Enter the path or click to navigate to it.

    This option restores the table and is generally used when the default directory does not have enough free disk space.

    NOTE: You can specify the default temp directory using the TempPath parameter in the [LiteSpeed] section of the LiteSpeedSettings.ini file. (Usually, C:\Documents and Settings\All Users\Application Data\Quest Software\LiteSpeed\SQL Server\LiteSpeedSettings.ini.)

    Direct Mode

    Select this option to import data directly into a table. This alternate data recovery mechanism eliminates the need for temp file space and uses BULK INSERT operations to recover the data.

    Recovery in-memory tables as regular tables

    Select to recover or restore memory-optimized tables as regular tables.

    Filegroup

    Select the filegroup. This option associates the restored object with the filegroup.

    Script options

    Select these options to generate scripts for table-related objects and constraints:

    • Script constraints except foreign keys - generate scripts for all constraints except for foreign keys
    • Script indexes - generate scripts for indexes
    • Script foreign keys - generate scripts for foreign keys
    • Script triggers - generate script for triggers
    • Script statistics - generate script for statistics

    Advanced options

    Bypass tail log processing is not selected by default.

    Tip: 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.

To restore schemas

Restore schemas can recover database objects - extended procedures, functions, partition functions, partition schemas, roles, rules, stored procedures, tables, memory optimized tables, triggers, types, users, views, indexed views, and XML schema collections.

  1. Click and run the Object Level Recovery Wizard.

  2. Select an object in the grid and click Recover Schema.

  3. Complete the wizard. Review the following for additional information:

    SQL Server

    Select a server instance or click to navigate to it.

    Database

    Select a database.

    LiteSpeed will not overwrite an existing object.

    Preview script

    Select to display a preview of the selected script.

    OK

    Click OK to initiate the schema restore.

 

Related Topics


Was this topic helpful?

[Select Rating]



Object Level Restores from TSM Backups

Object Level Restores from TSM Backups

You cannot do object level restores directly from a TSM backup, because TSM does not allow for randomly accessing the data.

To work around this issue

  1. Do one of the following:

    NOTE: To be able to extract TSM backups you need the Extractor tool delivered with LiteSpeed 5.2 or higher. This tool is fully backward compatible.

  2. Restore objects from the converted or native backup files using the Object Level Recovery tool.

 

Related Topics


Was this topic helpful?

[Select Rating]



Execute SELECT Statements

Execute SELECT Statements

The SQL Server SELECT statement is used to retrieve records from tables in a SQL Server database.

tip: Refer to Restore Objects in the LiteSpeed UI Console for further help with object restore.

To execute a SELECT statement

  1. Select the Script Execution tab. The available commands are displayed.

    Click to save script.
    Click to print script.
    Click to copy script.
    Click to find or replace a script.
    Execute Click to execute the script.
    Bypass tail
    log processing
    Click to bypass tail log processing.
    Save results in
    Database
    Click to save script execution results in a database.
  2. Enter the statement. For more information, see Supported SELECT Statements. about SELECT statements you can use in the LiteSpeed UI Console.

  3. Click Execute.

note: Be sure to use fully qualified names when you write a select statement.

 

Related Topics


Was this topic helpful?

[Select Rating]



Related Documents