Guidelines for Archiving Database
- Last UpdatedJun 06, 2024
- 2 minute read
Introduction
Archiving and purging data from the production database helps in maintaining a healthy system, and also in keeping the archived data for future use. An archiving strategy is a plan that ensures that the correct data is archived in a correct way. Archiving without a strategy might result in poor overall system performance. The most successful archival implementations are those that are well-planned by taking several important aspects into account.
Assess your needs for archiving by answering the following questions:
-
What data do we need to archive?
-
When do we need to archive this data?
-
How long do we need to maintain the archived data?
-
Under which circumstances and how often will we need to retrieve archived data from either table archives or file archives?
-
Do we require archived data that is stored in table archives to be moved to flat-file archives (i.e., do we require a multi-tier archiving strategy)?
Note: It is highly recommended that a Database Professional performs the tasks mentioned
in this document. The purpose of the document is to provide guidelines for archiving
AVEVA Work Tasks database. Essential maintenance tasks may vary based on specific implementation.
The Repository database and Farm database should reside on two different machines.
Benefits of Archiving
Archiving data reclaims disk space, lowers storage costs, reduces object maintenance, and improves the performance of active data.
The major benefits of archiving are interrelated. By reclaiming disk space that was consumed by inactive data, you can effectively lower your storage costs and reduce maintenance. As a result, access to your active data becomes more efficient. When less data exists, utility processing requires less time; thereby, reducing the batch processing times.
In addition, lowering costs is the most important benefit of archiving your inactive data. Also, applications might experience improved performance and use less CPU, I/O, and memory resources, which results in further cost savings.