The Databases tab of the Configure Repository Databases window allows you to view the status of your Repository databases and update event and attached archive databases created by earlier versions of IDERA SQL Compliance Manager.

Available actions

Edit Schedule

Allows you to change the specified scheduled for Repository maintenance activities such as rebuilding indexes.

Update indexes now

Allows you to update archive and event databases generated with earlier versions of SQL Compliance Manager. Updating the databases applies optimized indexes that improve the Management Console performance.

To update the databases, select the appropriate database, and then click Update Now. Be aware that this update process requires free disk space, may be resource-intensive, and may take some time to complete. Consider performing database updates during non-peak hours.

Available fields

Database Name

Provides the name of an individual Repository database.

Type

Indicates the type of database, such as an event database or an archive database.

Status

Indicates whether a Repository database should be updated to use the optimized indexes.

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels