Backing Up db_ControlManager Using SQL Server Management Studio

When using SQL Server, use the SQL Server Management Studio to back up the Control Manager database.


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

  1. From the Control Manager server, click Start > Programs > Microsoft SQL Server 2005 > Enterprise manager to access the SQL Server Management Studio.
  2. On the console, click Microsoft SQL servers > SQL server group > {SQL server} (Windows NT) > Databases. {SQL server} is the SQL Server host name.
  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.