Backing up a Control-M/Server MSSQL database

This procedure describes how to back up a Control-M/Serer MSSQL database onto a backup device. BMC recommends that you back up your Control-M/Server databases onto backup devices daily. You can complete this procedure while the database is running.

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

To back up a Control-M/Server MSSQL database:

1. Display the Control-M Main Menu by typing the ctm_menu command.
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 List Backup Devices option, and write down the name of the device that you want to use.

   When backing up an MSSQL database, the full path is a path on the database server computer.

4. Return to the Database Maintenance menu, and enter the number of the Backup Database option.
5. Enter the name of the backup device you wrote down in step 3.

   The backup device must be either a valid device defined in the SQL database, or the full path name of a file to be created by the backup procedure.

6. Respond to the subsequent prompts that are displayed.
7. When you are done, enter q to quit.

   The Control‑M/Server database is backed up onto a backup device.