ctmdbrst

The ctmdbrst utility restores the Control‑M/Server database in the following cases:

• Control-M/Server was installed by using a dedicated PostgreSQL database server. Do not use this utility if Control-M/Server was installed with an Oracle database (either existing or dedicated) or an existing PostgreSQL database.

• To restore an existing Oracle database or a PostgreSQL database, use the ctm_restore_bcp utility, as described on ctm_restore_bcp.

• Control-M/Server was installed by using an MSSQL database server.

For more information about backup types, see Database Operation and Maintenance.

To restore the Control-M/Server database, see Restoring the Control-M/Server Database.

Running the ctmdbrst Utility

This procedure describes how to run the ctmdbrst utility, which restores the Control-M/Server database.

Begin

1. Do one of the following:

   • UNIX: Log in to a Control-M/Server account.

   • Windows: Open a command prompt window where Control-M/Server is installed.

2. Do one of the following:

   • To invoke the ctmdbrst utility for Control-M/Server installed with MSSQL, enter the following command:

     ctmdbrst
     [ -f<administrator password file>]

     [ -d<full path of backup directory/file>]

     [ -m H/C]

   • (UNIX only) To invoke the ctmdbrst utility for Control-M/Server installed with PostgreSQL, run the following command:

     ctmdbrst [ -p<administrator password>]

     [ -f<administrator password file>]

     [ -d<full path of backup directory/file>]

     [ -a<full path of archive directory>]

     [ -m<restore mode H/C>]

   • (Windows only)Enter the following command at the command prompt to use the interactive menu:

     ctmdbrst

Restoring the Control-M/Server Database

This procedure explains how to restore the Control-M/Server database by using the ctmdbrst utility.

Begin

1. Shut down Control-M/Server and the Configuration Agent before invoking this utility. Make sure that no other users or processes are connected to the SQL server.

2. Do one of the following:

   • UNIX: Log in to a Control-M/EM database account

   • WINDOWS: Open a command prompt window where Control-M/EM is installed.

3. Enter the following:

   ctmdbrst

   Continue the restore procedure by following the prompts.

For MSSQL – you are prompted for the backup device (<backupDevice>). This device was used to back up the Control‑M/Server database.

Running the ctmdbrst in silent mode

This procedure describes how to run the ctmdbrst utility in silent mode.

Begin

1. Do one of the following:

   • UNIX: Log in to a Control-M/Server account

   • Windows: Open a command prompt window where Control-M/Server is installed.

2. Enter the following command:

   ctmdbrst -pmanager –d<restoreDirector> -m<H/C> -a<archive Director>

   The following command causes the Control-M/Server database to be restored from the default backup device:

   ctmdbrst