DAS Database Backup Best Practices
search cancel

DAS Database Backup Best Practices

book

Article ID: 286513

calendar_today

Updated On:

Products

Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

Best practices for creating and managing the das database backups.

Environment

  • App Control Server: All Supported Versions
  • Microsoft SQL Server: All Supported Versions

Resolution

  • The App Control database uses the "Simple" recovery model. The "Full" recovery model should not be used to avoid a performance penalty and excessive database log growth.
  • The automated database backup feature built into the Console is not designed for deployments of more than 100 endpoints.
  • For deployments of more than 100 endpoints a Maintenance Plan should be created via SQL Server Management Studio.
  • Recommended frequency for full backups is no more than 2-3 per week. More frequent backups could impact server performance.
  • Backups may impact performance and should be avoided during busy times (such as App Control Server maintenance tasks, typically between midnight and 6AM)
  • Backups should not be stored on the same drive as the App Control database.

Additional Information

  • More information can be found in the SQL Backup section of the Operating Environment Requirements found on VMware Docs > Server Documentation > OER > SQL Backups.
  • Differential backups are not recommended as the "das" is a constantly changing database.