Restoring a Control-M/Server MSSQL database from a backup

This procedure describes how to restore the Control-M/Server MSSQL database from a database failure or data corruption.

NOTE: Performing this procedure has the same effect as running the ctmdbrst utility.

To restore an MSSQL database from a backup device:

1. Display the Control-M Main Menu (ctm_menu).
2. In the Control-M Main menu, enter the number for the Database Maintenance option.
3. In the Database Maintenance menu, enter the number for the Restore Database option.
4. Follow the displayed prompts.

   The backup device must be a valid device defined in the database, or the full path name of a backup file to be used as input for the ctmdbrst utility.

   If you do not know the name of the backup device, display the list of backup devices by entering the number of the List Backup Devices option in the Database Maintenance menu, and then note the name of the device.

5. Type q to quit.

To recover from a hot restore failure (for PostgreSQL):

1. Stop any PostgreSQL processes currently running on the computer.
2. Go to the pgsql parent directory. On UNIX for example, this directory is the user ctm_em directory.
3. Check if pgsql_old_<current_date> exists. If so, this means that the restore process renamed the old (now corrupted) directory.
4. Rename it to pgsql.
5. Start the PostgreSQL server.