Modify the Access Definition

Define the subset of data to restore by applying local selection criteria and modifying the Access Definition.

In a Restore Request, you can modify the Access Definition associated with a listed Archive File before restoring the data to a database. For example, you can change the Start Table, deselect relationships, and change options that determine the traversal path between tables in the Archive File.

Any changes to the Access Definition are saved in the Restore Request as a Modified Access Definition and do not affect the original Access Definition used in the Archive Process.

Because you want to restore orders for a specific customer, you must change the Start Table from ORDERS to CUSTOMERS in the Access Definition.

Change the Start Table

In the Archive Files grid, right-click the file name and click Browse > Access Definition > Original from the shortcut menu.

Restore Request Editor with Browse > Access Definition > Original clicked from the shortcut menu

The Access Definition used to archive the data is displayed in the Access Definition Editor. To change the Start Table, select CUSTOMERS in the Start Table drop-down list.

Access Definition Editor with Tables as the active tab. Icons display for the ORDERS and CUSTOMERS tables in the grid under Table Specifications.

Review the Traversal Path

Archive follows the traversal path when selecting data from tables in the Archive File. You can click the Relationships tab to review or change the options that define the traversal path. The current settings for each relationship are appropriate and direct Archive to:

When finished, click File > Update and Return from the menu to return to the Restore Request Editor. Note that the Modified AD check box is selected in the Archive Files grid.