Log Database Cleanup (Web and Email)
In order to resolve the issue for Web and Email products, follow the steps below.- Log on to the Forcepoint Security Manager (formerly Triton).
- Click Settings > Reporting > Log Database.
- Scroll down to the particular partitions you want to Delete or Disable.
- Select which partitions you wish to disable/delete by marking the checkbox to the left of each.
- Press disable/delete as per the picture below in red.
- Note If attempting to delete a Disabled partition, it must be made active again first.
- Select the Disabled partition and click the Enable button.
- Press OK, then <ol start="50">.
- Open SQL Management Studio and log in with admin credentials.
- Expand Databases > wslogdb70 (or similarly named for your database if not default). Right-click the database deleted from Forcepoint Security Manager and select Tasks > Detach.
- Select Drop Connections and Update Statistics then click OK.
- Locate the .mdf and .ldf files with the same name as the partition and delete them from the hard drive. To locate the files, check the path listed in Settings > Reporting > Log Database for Data and Log.
To automatically delete older database partitions:- In Forcepoint Security Manager, go to Settings > Reporting > Log Database.
- Navigate Database Maintenance, which is below the large graph.
- Select Automatically delete partitions when data is older than: ___ days.
- Enter the Data Retention policy day amount for your organization.
- Press OK, then Save and Deploy.
- On the next maintenance task run, any partitions with the last file matching the day after the set date will be removed.