20.1 Database Maintenance Checklist

The following checklist outlines the typical database maintenance workflow. Use this checklist to understand the database maintenance process and help you implement the best maintenance strategy for your organization.

 

Checklist Items

  1. Verify the appropriate permissions in Microsoft SQL Server and Secure Configuration Manager. See Required Database Permissions and Settings.

  1. Understand how the Secure Configuration Manager database stores and manages data. See How the Secure Configuration Manager Database Works.

  1. Identify and implement the appropriate database maintenance strategy for your organization. See Developing a Database Maintenance Strategy.

  1. Ensure data preservation and history by scheduling routine backups.See Backing Up the Secure Configuration Manager Database.

  1. Ensure optimal database performance through routine grooming. See Grooming the Secure Configuration Manager Database.