Why doesn the Archive Table Data action copy indexes or relationships?
Indexes and relationships could interfere with Total Visual Agent’s ability to perform an archive of your table. Total Visual Agent makes a copy of each table individually. 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 archiving 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 an Archive Table Data action to
