SQL Server database maintenance

Every morning at 5 am the Access Rights Manager server completes scheduled maintenance by removing and archiving old scans from the Access Rights Manager data base. These settings can be managed in the menu item server in the storage of scans section.

Scheduled data base maintenance is only performed if all Access Rights Manager user interfaces are closed. You can identify logged in users in the menu item server status.

Shrink database logs

1. If you do not see the icon for step 2, click the refresh button.
2. Shrinking of data base logs frees up disk space. The action is performed immediately after clicking the button. You do not need to save the configuration again.
3. The actual size of the log file is shown.

Shrink database

1. If you do not see the icon for step 2, click the refresh button.
2. Shrinking the data base frees up disk space. The action is performed immediately after clicking the button. You do not need to save the configuration again.

For more information on data base size or available disk space please see: Server Health-Check.

Please see additional notes on SQL Express Edition.

For additional information see the article Shrink a File (© 2020 Microsoft, https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-file, obtained on November 1, 2021).