App Control: Database Data File Size Limit Reached

[#1]

Environment

• App Control Server: All Supported Versions
• SQL Server Express Edition: All Supported Versions

Symptoms

• Events are seen in the Console with an error similar to:
• "Database data file size limit reached. Total data file size is 3077 MB."

Cause

SQL Server Express Edition has a maximum database file size of 10GB. App Control will default to a cutoff size of 3.7GB (3700MB) when SQL Server Express Edition is used.

Resolution

To increase the allowed database size:

1. Login to the Console and navigate to: https://ServerAddress/shepherd_config.php
2. Locate the Defined Property: MaxDatabaseSizeMB and change the Value to: 8192
3. Click Change to save the new setting.

Additional Notes

• If it is expected that the database size will continue to grow beyond 10GB, an upgrade to SQL Server Standard Edition will be required.
• The Alert is configured to warn when the database is approaching the limit.
• The Shepherd Config Property, DisableTrackingCutoffDatabaseSizeMB may need to be adjusted as well.

Related Content

App Control: How to Free Space in the DAS Database
App Control: Files on Computers Missing New Files and File Prevalence Not Updating