GFI EndPointSecurity Database backend is growing rapidly

Answer

PROBLEM

The backend database is much bigger than it should be and is taking up a lot of space on the hard drive.

ENVIRONMENT

GFI EndPointSecurity

All Supported Environments

SOLUTION

Set the Recovery Model for the database(s) to Simple in the SQL Management Studio

Then perform a Shrink on the database. This will reduce the size of the transaction log to a couple MB.

If the database itself is too large:

Restrict the events they are collecting by adjusting the Filter in the Logging and Alerting Settings in each policy

Configure Database Maintenance to move / delete data

CAUSE

By default, EndPointSecurity sets the Recovery Settings for the database to Full. This causes the transaction log to grow very large. If you look at the size of the database, you will see that the size of the transaction log will be very large. Once you set it to Simple Recovery Mode as soon as transactions are written to the database, the transactions can be overwritten.