Restore backup db_ControlManager Using SQL Server Enterprise Manager

Use the SQL Server Enterprise Manager to restore the backup Control Manager database.

To restore backup db_ControlManager:

1. From the Control Manager server, stop the Trend Micro Control Manager and Trend Micro Management Infrastructure services.

2. Click Start > Programs > Microsoft SQL server > Enterprise manager to access the SQL Server Enterprise Manager.

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

4. Right-click db_controlmanager and then click All tasks > Restore Database….

5. On the Restore database, select the database to restore.

6. Click OK to start the restoration process.

7. Click OK when the message "Restore of database '{Control Manager database"}' completed successfully."

8. Restart the Trend Micro Control Manager and Trend Micro Management Infrastructure services.

See also:

Back up db_ControlManager using SQL Server Enterprise Manager