Our NetWrix Event Log Manager database size is getting too large. How can we reduce its size and delete old events?
You can reduce the database size by setting the SQL database retention period that allows controlling the amount of data stored in your SQL database. In accordance with this setting, the database size is automatically updated during the event collection process.
To configure the SQL database retention settings, do the following:
- Start NetWrix Enterprise Management Console, and navigate to Managed Objects <your Managed Object> Event Log Manager Reports.
- In the right pane, switch to the Settings tab, select the Store audit data in the database for () days check box, and specify the number of days (for example, 30 days). Note: the longer the period you specify, the larger your database size is.
- Click Apply to save the changes.