Backing Up db_ControlManager Using the SQL Server Enterprise Manager

In an event when the Control Manager database is corrupted or destroyed, use a backup copy to restore your settings. When using SQL Server, use the SQL Server Enterprise Manager to back up the Control Manager database.

To back up db_ControlManager using the SQL Server Enterprise Manager:

  1. From the Control Manager server, click Start > Programs > Microsoft SQL server > Enterprise manager to access the SQL Server Enterprise Manager.

  2. On the console, click Microsoft SQL servers > SQL server group > {SQL server} (Windows NT) > Databases. {SQL server} is the SQL Server hostname.

  3. Right-click db_controlmanager and then click All tasks > Backup Database….

  4. On the SQL Server Backup - db_controlmanager, specify the database name and description.

  5. Under Backup, select Database - complete.

  6. Under Destination, click Add to specify the backup file destination.

  7. On Select Backup Destination, provide the database backup name and path where it will be saved and then click OK.

  8. On the SQL Server Backup - db_controlmanager, click OK to start the db_ControlManager backup.

  9. Click OK when the message "The backup operation has been completed successfully." appears.

  10. Trend Micro recommends regular back ups of the Control Manager database. Always back up when you are about to modify the Control Manager database (for example, adding installing a managed product).

See also:

Restore backup db_ControlManager using SQL Server Enterprise Manager