Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Restoring Deleted Data After a Failed Reset

Restoring Deleted Data After a Failed Reset

If you need to restore data that was deleted during a failed reset operation, you can restore the data from the backup created during the reset. Run a separate plan to restore the data from the backup. Ensure that you have the backup prefix used during the failed reset operation.
Perform the following high-level steps to restore data from the backup schema:
  1. Create a group that contains all the tables that were backed up during the reset operation.
    The backed up tables include all transactional tables.
  2. Open a project and create a plan.
  3. Add the group as a subset component to the plan.
  4. Add the connection that contains the backup schema as the source connection.
  5. Add the database where you want to restore the data as the target connection.
  6. In the target settings in the plan, disable the constraints and indexes.
    Select the following values for the
    Update Strategy
    properties:
    • Treat Source Row As
      : Update.
    • Update As
      : Update else Insert.
  7. In the
    Advanced Settings
    , enter the backup prefix in the
    Reset Recovery Prefix
    field.
  8. Run the plan.