9.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 Section 9.2, Required Database Permissions and Settings.

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

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

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

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