Page History
Updating your archive databases allows you to take advantage of the performance enhancements provided by optimized indexing in the latest version. When you update an archive database, IDERA SQL Compliance Manager locks the Repository and applies the new indexing scheme to the specified database.
...
Update your archive database using the Management Console
To update archive databases using the Management Console:
- Attach existing archives.
- Select Auditing > Configure Repository Databases.
- On the Configure Repository Databases window, select the Databases tab.
- Select the databases you want to update, and then click Update Now.
Update your archive databases using the CLI
To update your archive databases using the CLI:
- From a DOS prompt, navigate to your SQL CM Compliance Manager installation directory.
- Enter the following at the prompt:
SQLcmCMD updateindex –all
Scroll pdf ignore | ||||
---|---|---|---|---|
Newtabfooter |
|
SQL Compliance Manager audits all activity on your server. Learn more > >
...
...