The Archive process

Archiving is a multi-step process. When archiving is initiated, the data to be archived is placed in a temporary table. The temporary table is copied to disk and the new file is copied to an archive file on the archive device. The Archive device is configured in the Archive schedule table. An Archive file name takes the following form:

system_service_database_table_date.archive_version

where:

system is the name of the local system.

service is the name of the service that contains the archived data; the default value is Archive.

database is the name of the database that contains the archived data.

table is the name of the table that contains the archived data.

date is the Archive date.

version is the version number of the Archive, starting with 0.The version number is incremented if data is rearchived.

Note: AVEVA Enterprise SCADA Services running SQL Server may be scheduled for archiving data.

A log of the Archive is written into the catalog table and the date of the Archive is recorded in the schedule table.

Data is automatically archived when it becomes older than the date specified by the Archive Cutoff date set in the Archive schedule table. The is used to set this value. The format of the Archive Cutoff field entry contained in this form is YY:MM:DD. YY, MM, and DD specify the number of years, months, and days, respectively, that should elapse before the specified data can be archived.