When recovering tables using Object Level Recovery - Tables from LiteSpeed Wizard, the indexes / constraints are not being created.
LiteSpeed Object Recovery - Tables is designed to work that way; where it only creates the table structure and imports the data. To generate the indexes and constraints for the table, you have to use the "Object Recovery - Schema" and generate the index and constraint creation script from there. Run the script after the table data has been recovered.
See attached PowerPoint presentation for the detailed steps.
Beginning with LiteSpeed Version 4.6, Object Recovery supports the recovery indexes, constraints and triggers by Object Level Recovery - Schema.
Object Level Recovery is only available with the LiteSpeed Professional license. To determine license type, run master.dbo.xp_sqllitespeed_version in Query Analyzer.
