When iFIX ODBC re-establishes a connection with the server, it automatically restores the backed up SQL commands in chronological order, starting with the first backed up SQL command. iFIX ODBC restores backed up data as described below:
- All backed up SQL commands are restored from both primary and secondary back-up files.
- iFIX ODBC processes backed up SQL commands in the order in which they were backed up. This means that the backed up SQL commands are processed in a first in, first out (FIFO) basis.
- Once all SQL commands are restored, the system deletes the back-up files.
NOTE: If large back-up files are created, restoring the SQL commands and data can take a considerable amount of time. However, new SQL commands from the SCADA node are also processed while the files are restored.
