Search Archived Data

Search Archived Data

Search archived data prior to a restore  Create valid SQL queries on multiple columns in the selected table by using "AND" or "OR" between each individual query.

Select ... From

This box displays the archive query.  Queries must be a valid SQL query, starting with "Select <Column Name...> from Table Name WHERE" and can either be entered directly her, or by using the Columns and Operators.

Table Name

The table the query is performed against. By default this is populated with the selected Archiving Table.

Columns

All the columns for the Table Name.

Operators

The list of operators to use in the query.

Search Archived Data

This executes the SQL query.  Results are displayed in the Data Preview dialog box.