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:
- Login to the application server as the Carbon Black Service Account and launch SQL Server Management Studio.
- 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)
- Confirm that the DailyPruneTask is completing successfully (Support.php > Scheduled Tasks tab)
- Evaluate adjusting the Old Computer Cleanup options
- Evaluate lowering the Event Retention settings
- Evaluate discarding Microsoft-signed Files at the Agent.
- Evaluate configuring Zero Prevalence Pruning.
- Manually running the DailyPruneTask stored procedure could help reduce the database size if it has failed to execute recently.
- 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
