SQL Server database maintenance

Each morning at 5 AM, the ARM server completes the scheduled maintenance by removing and archiving old scans from the ARM database. You can manage these settings in the storage of scans settings.

ARM performs the scheduled database maintenance when all ARM user interfaces are closed. You can identify logged in users in the License Information and Server Status window under Server Status.

See SQL Server Express and Access Rights Manager to review the limitations with using SQL Server Express for your ARM database.

Shrink the database logs

To reclaim additional hard drive space, consider shrinking the database logs.

1. If you do not see the icon for step 2, click the refresh button.
2. Shrinking the database logs frees up disk space. This action occurs immediately after clicking the refresh button. You do not need to re-save the configuration.
3. The log file size displays in the window.

Shrink the database

1. If you do not see the icon for step 2, click the refresh button.

2. Shrinking the database frees up additional disk space. This action occurs immediately after you click the refresh button. You do not need to re-save the configuration.

   See Shrink a file located on the Microsoft Learn website at learn.microsoft.com for information on how to shrink a data or log file in SQL Server using SQL Server Management Studio.
   See Determine the server thresholds for details on how to check the database size and available disk space using Server Health Check.