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 - Undo or Redo Commands
Use the Undo/Redo wizard to generate the SQL script to rollback a transaction or to undo or redo individual DML or DDL commands executed on the database, as recorded in the loaded log file. For more information, see Supported DDL and DML Commands.
To access the wizard to undo or redo individual commands
- Select the DML/DDL page in the Log Reader window.
-
Select the checkbox next to each command that you want to undo or redo.
Note: If you select multiple commands, you can either undo all these commands or redo all the commands. You cannot mix the undo and redo operations within the selected group of commands.
- Click Undo/Redo Wizard
on the Log Reader toolbar.
- Complete the wizard.
To access the wizard to rollback an entire transaction
- Select the DML/DDL page in the Log Reader window.
- Select the checkbox next to a command that belongs to the transaction you want to roll back.
- Right-click within the command list, and select Rollback Transaction. All commands that were executed within that transaction are automatically selected.