The system specialist is responsible for maintaining the database. These tasks include the day-to-day operation of the database and routine maintenance tasks. To access Database Tools, choose File➛Open Servers and Databases. The server name list in the main window displays servers available for connection. Each server name is expandable to show the databases available on that server.

Certain database maintenance tools are available to Standard databases only. Table 10‑1 shows which database maintenance tasks are available to each database type.

Metrics Management supports remote access to the following database maintenance tools:

Verify database is not available by remote access to SQL Server and Oracle databases. Metrics Management does not support remote access to the compact, copy and backup, and duplicate database tools. Copy and backup requires providing a local path destination for the database backup.

To perform operations in Database Tools with User Account Control (UAC) enabled, ensure that Metrics Management is allowed elevated permissions by running Metrics Management as an administrator.

Before performing actions on a database, select the database in the main window.