About Backing Up/Restoring with LiteSpeed
LiteSpeed User Interface
Configure LiteSpeed for First Use
Register Repositories
Register and Group Server Instances
Cloud
Back Up Databases
Register Servers
Create Server Groups
Assign Servers to Server Groups
About Categorizing Servers
Change Server Grouping Methods
Create Categories
Assign Servers and Databases to Categories
Configure [[[Undefined variable Primary.Product_Name]]] Defaults
Configure LiteSpeed Options
General Options
Backup Manager Options
Log Shipping Options
Configure Job Manager Options
Set Log Reader Options
Configure Replication and Retention Options for Repositories
Create and Deploy Backup Templates
Back Up Using the Backup Wizard
Back Up Multiple Databases
Automate Maintenance Tasks
Logic for Backing Up Multiple Databases
Use Wildcard and Regular Expressions in LiteSpeed
Multi-Database Backup Wizard
Fast Compression
Compression Levels
Encryption
Double-Click Restore Executables
Network Resilience
SmartCleanup
Accepted Variables
About Creating Maintenance Plans
Back Up Databases
Clean Up Maintenance Data
Copy Maintenance Plans
Automate Similar Backup Tasks on Multiple Instances
Restore Databases
Restore Objects
Restore Tables in [[[Undefined variable Primary.product_UI]]] Console
Object Level Restores from TSM Backups
Execute SELECT Statements
Supported SELECT Statements
View Activity and History
Use Command-Line Interface
LiteSpeed Command Line Arguments
Fast Compression Command-Line Agruments
SmartCleanup Command-Line Arguments
Script Maintenance Plans Tasks
Recast Litespeed Backups
Convert [[[Undefined variable Primary.product_Name]]] Backups to SQL Server Backups
Restore Objects with the Command-Line Interface
LicenseInfoCmd Utility
Use Extended Stored Procedures
About Using Extended Stored Procedures
Backup examples - extended stored procedures
xp_backup_database
xp_backup_log
xp_delete_tsmfile
xp_encrypt_backup_key
xp_encrypt_restore_key
xp_extractor
xp_memory_size
xp_objectrecovery
xp_objectrecovery_createscript
xp_objectrecovery_executeselect
xp_objectrecovery_viewcontents
xp_restore_attachedfilesonly
xp_restore_automated
xp_restore_checkpassword
xp_restore_checksumonly
xp_restore_database
xp_restore_filelistonly
xp_restore_headeronly
xp_restore_setinfo
xp_restore_log
xp_restore_verifyonly
xp_slsCreateDCR
xp_slsFastCompression
xp_slsReadProgress
xp_slsSmartCleanup
xp_slssqlmaint
xp_sqllitespeed_licenseinfo
xp_sqllitespeed_version
xp_view_tsmcontents
xp_view_tsmmc
Troubleshoot LiteSpeed
Troubleshoot LiteSpeed Activity
Troubleshoot Maintenance Plans
Troubleshoot Performance-Related Issues
Troubleshoot Previous Versions of LiteSpeed
Configure LiteSpeed Logging
Create Support Bundles
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
- Run the Read Log Wizard. For more information, see Read Transaction Logs.
- Select the DML/DDL page in the Log Reader window.
- Click
on the Log Reader toolbar.
- 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.