Data Archive

Print Top  Previous  Next

The Data Archive utility creates and/or restores transaction and alarm archives.   Access this utility by clicking on Start > Programs > WebBrix > Data Archive. (see figure Data Archive)

Data Archive

Data Archive

 

When creating an archive there are three "Operation" options:

 

Copy All Data: This operation will copy all of the data from the operational logs to the archive files.  The data will remain active in the database.  This operation is intended for making complete copies of logs.
Copy Data: This operation will copy the specified data from the operational logs to the archive files.  The data will remain active in the database.  This operation is intended for making copies of specific data.
Archive (Move) Data: This operation will move the specified data from the operational logs to the archive files.  This operation is intended for long-term storage of data this is not likely to be needed again.  To run reports against this data, restore the data first.  Specify the amount of data to keep in the active log.

 

After verifying the Archive Path and Operation, click the Copy/Archive button in the upper right hand section of the window.  The Status box will show a realtime account of what the archive utility is doing and a log will be generated in the Activity Log window.  When completed, the Status box will read "Idle".

 

The archived files will be placed in the location specified in Archive Path.  These files are SQL .dat files and have the following naming convention.

 

YYMMDD-X_ArchiveName.dat

 

YY is the 2 digit year, MM is the 2 digit month, DD is the 2 digit day and X is a zero based counter that increments for every archive done for a specific day. (see figure Archives)

Archives

Archives

 

In addition to the .dat files there are .arh files that are used by the Data Archive utilities restore feature. It's important to place all these files in a safe place.

 

To restore an archive, click on the Restore Archives tab (see figure Restore Archive).  Select a archive from the grid and click Load Archive.  The Status box will show a realtime account of what the archive utility is doing and a log will be generated in the Activity Log window.  When completed, the Status box will read "Idle".

 

Restore Archive

Restore Archive

 

To change the "create" or "restore" locations, use the Archive Path tab.

 

 


Page url: http://support.amt-us.com/amtdn/index.html?database_archive.htm