Reduce SQL transaction log file

Overview

This article details how to reduce the SQL transaction log file through the basic configuration of ARM. For this, the configuration interface must be started.

Environment

• Access Right Manager

Details

It is recommended that SQL file reductions are completed when all ARM users are disconnected from the system.

Resolution

1. Click on the basic configuration icon.
2. Click Recheck. A confirmation message "Configuration successfully loaded!" is displayed when recheck is complete.
3. The buttons to the Recovery Model appear to change, or to zoom out, the database or SQL transaction log file:
   1. Switch to simple/full recovery mode
   2. Shrink the database log files
   3. Shrink all database
4. Select the "DB Decrease logs" option. ARM reloads with the Decrease applied.
5. (Optional) Set the retention period of scanned images in the database to a shorter interval.
   1. Start the configuration interface.
   2. Click on the menu server.
   3. Under Storage of Scans, specify the length of time Active Directory and File Server scans are to be stored in the database.

      The number of days for Active Directory can be unique, 180 days and 5 months. If you do not need 180 daily scans, set 30 days + 5 months, for a total of 6 months. Please note: when set to 30 days for the scans, the first month 29 days for the first month remains in the archive, and one day remain active. The database archive is then created and the data for the cleanup no longer exists.

If the Scan archive is turned on, scans that are not stored in the database are not lost and remain to be cleared in the scan archive. Data from the scan can archive, as well as scans that are still stored in the database, can be loaded at any time in ARM.