# 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 need. 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.ArchiveTatgets
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