Total Visual Agent makes a copy of each table individually. Indexes and relationships could interfere with Total Visual Agent's ability to perform an archive of your table. If relationships require certain values to exist in other tables, it may fail to save your records due to missing records in the tables it depends upon. By not including indexes and relationships, it avoids problems associated with the order tables are populated.
You should archive individual tables when it's not possible to make a complete database backup (if users are in the database). The purpose of the table data extract is recovery of data that was added since the last time a complete copy of the database was made (with the Archive action).
The recommended backup procedure for databases that are heavily updated during the day is:
- Perform an Archive Database action one or more times a day at a time when nobody is using the database, such as the middle of the night.
- Schedule a Table Data Extract action to run several times throughout the day (e.g. every hour) to extract the data from the most crucial tables.
In Total Visual Agent 2013, this action now creates tables with basic indexes and properties. This and many other new features were added in the 2013 version.