Working with the Database
In order to keep the Atlas Copco Data Communication database up and running with good performance and reliability, the following maintenance activities are recommended:
Make regular backups of the database to secure the data in case of hardware failure and to keep the transaction log from growing in size.
Rebuild and reorganize the indexes in the database regularly, to keep the transactions and searches fast and optimized.
Delete old results that are no longer needed. This reduces the required disk space and improves report creation speed. After a Delete maintenance job it is also recommended to reorganize the indexes.
To run the maintenance job, setup and start the job scheduler manager for required database type.
A | Linked Server | B | Archiving Job |
C | Atlas Copco Data Communication DB | D | Table: dbo.ArchiveTargets |
E | Database Server | F | Archive db example: Period 1 |
G | Archive db example: Period 2 | H | Atlas Copco Data Communication Archive Database |
I | Archiving Service | J | Atlas Copco Data Communication Application Server |
