IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

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
  • Microsoft SQL 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. Login to the application server as the Carbon Black Service Account and launch SQL Server Management Studio.
  2. Changing the Database Recover Model from Full to Simple can reduce size. To shrink log after changing recovery model, execute the query:
    use DAS
    DBCC SHRINKFILE (N'das_log' , 0, TRUNCATEONLY)
  3. Confirm that the DailyPruneTask is completing successfully (Support.php > Scheduled Tasks tab)
  4. Evaluate adjusting the Old Computer Cleanup options
  5. Evaluate lowering the Event Retention settings
  6. Evaluate discarding Microsoft-signed Files at the Agent.
  7. Evaluate configuring Zero Prevalence Pruning.
  8. Manually running the DailyPruneTask stored procedure could help reduce the database size if it has failed to execute recently.
  9. If not using the CPE or CVE feature, be sure the data is fully removed and the feature disabled.
Note: The database may need to be shrunk again if changes were made, or after Zero Prevalence Pruning has had several days to work through changes.

Additional Notes


Related Content


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