Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: How to Free Space in the DAS Database

App Control: How to Free Space in the DAS Database

Environment

  • App Control Server: All Supported Versions

Objective

To free up space in the DAS database.

Resolution

Warning: Ensure there is a full backup of the das database before proceeding and before each additional step
  1. Changing the database recovery model from "full" to "simple" can reduce size:
  2. Confirm DailyPruneTask is running each night:
    select task, delay_before_next_exec, last_exec_time from dbo.scheduled_tasks;
    -- Confirm has a last_exec_time within 48 hours
  3. Manually running the DailyPruneTask stored procedure can help reduce size of database
  1. Considering setting "Old Computer Cleanup":
  2. Lowering the event retention settings can reduce size:
  3. Pruning 0 prev files can reduce size of database:
  4. Running FilenamePathnameReseed_X.X.X.bat can reduce size:

Additional Notes

Warning: The das database does not automatically run a "shrink" after information is removed. A "Shrink" will need to be ran to get the unused space back:

Labels (1)
Tags (2)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎08-26-2020
Views:
2078
Contributors