# Creating the Archive Database

How to create a database archive on a server.

Before creating an archive, make sure that all data received from the controller—results, programs, step events, jobs, and other relevant records—include a real-time timestamp. This requirement is essential for accurate data tracking and reliable archiving.

Installation is applicable to SQL Server.

The Archive Installer has guiding text for each field.

1. In the Archive Installer dialog box, go to the Create Archive tab and enter the fields as stated below.

2. DatabaseInstaller path - The path is by default set to C:\ProgramData\Atlas Copco\ToolsNetDatabase\ToolsNetDatabase scripts\AtlasCopco.DatabaseInstaller.exe.

3. Archive instance - Enter an IP address or archive database server, where the archive target database is to be stored.

4. User Name - Enter the name of the user to be used for the archive database.

5. Password - Enter the password used for the archive database installation.

6. Archive name - Enter the name to be used for the archive database.

7. Archive Location - Enter or browse the location of where the archive database is to be saved. The location needs to be in the C drive and it needs to be manually added if on a remote server.

8. Only available in database type SQL.

   Log file location - Enter or browse the same location used in Archive Location . The location needs to be manually added if on a remote server.

9. Select Install to run the installation to create the database for archiving.

10. - If the installation has been successful a dialog box will be displayed. Select OK .

    - If the installation has been unsuccessful, an installation error dialog box will be displayed. Select OK and go back and check the entered fields.

For the database archive to work, a link needs to be configured between the archive database and the ToolsNet database. See Creating Link to the Database.