Database maintenance

Configuration: DOC -> Settings -> Backend -> Database & event data maintenance

Database maintenance is used to limit data growth and maintain indexes on table columns to ensure best possible performance even with large data volumes.

We recommend that you configure the database maintenance options in DriveLock Enterprise Service only if you are using SQL Server Express version (e.g. MSDE 2000, SQL2005 Express, SQL2008 Express). When using the full version of SQL Server, we recommend that you set database maintenance manually on the server. For more information, please contact our support or refer to the Database Guide under Technical Articles at DriveLock Online Help.

  • In the Clean up event data now section, you can limit the growth of the SQL database by having the DriveLock Enterprise Service automatically delete old events. To do so, use the Start cleanup option. Enter the maximum age of the events. Note to set database cleanup if you do not need to run reports or forensic analysis on old data, or if you archive your SQL data with a third-party tool.

  • You can start database maintenance in the Database maintenance section. By default, all events older than 30 days are automatically deleted on a daily basis. Maintenance of the indexes on the table columns is also activated via this option. This optimizes the search. By default, database maintenance is performed automatically on a daily basis.

  • The Delete inactive computers section allows you to free your system of any inactive computers. Inactive computers are clients with DriveLock Agents installed that have not logged back into the server for a certain period of time. You can specify this time here and also the number of inactive computers you want to have deleted per cleanup. In this context, 'delete' means that the computer will no longer appear in your lists and displays and that group memberships, events and recovery data, along with all other data, will be deleted (depending on the option selected). However, the DriveLock Agent remains on the computer so that it can reappear in the system when you log on again.

    To automate this action, you can specify the following setting: DOC -> Settings -> Backend -> Client settings -> Maintenance -> Delete inactive computers.

    If you want to protect certain computers from being deleted, DriveLock provides a static group by default you can add these computers to. This 'DoNotDelete_ComputerGroup' then contains, for example, computers belonging to management, administrators or employees that may be offline for longer periods without actually being classified as inactive. It is created by the system as soon as you have activated the automatic deletion of inactive computers and can also be deleted again if deactivated. The group name and description can be customized and individual members can be removed.