Chat now with support
Chat with Support

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

Log Reader - Recover Tables

Use the Recover Table wizard to recover a table that was dropped or truncated, as recorded in the transaction log. The Log Reader re-creates the table in the database and reloads the data.

To recover a dropped or truncated table

  1. Run the Read Log Wizard. For more information, see Read Transaction Logs.
  2. Select the DML/DDL page in the Log Reader window.
  3. Click on the Log Reader toolbar.
  4. Complete the wizard.

Notes:

  • The table is recovered if there are any data. If not, use the Undo/Redo wizard to recreate the table. For more information, see Undo or Redo DML or DDL Commands.
  • The table is recovered with its original name. If another table with the same name already exists in the database, the Log Reader automatically generates an index and appends it to the name of the recovered table.
  • Use the path to LSM file advanced option to change the path to the Maint Plans LSM file.
  • Use the bypass tail log processing advanced option to bypass tail log processing. Object Level Recovery operations may work faster.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating