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:
Create a group that contains all the tables that were backed up during the reset operation.
The backed up tables include all transactional tables.
Open a project and create a plan.
Add the group as a subset component to the plan.
Add the connection that contains the backup schema as the source connection.
Add the database where you want to restore the data as the target connection.
In the target settings in the plan, disable the constraints and indexes.