Restore Backup db_ControlManager Using osql

Use the MSDE command line interface that comes with your version of MSDE, <root>:\Program Files\Trend Micro\MSDE\osql, to restore backup database.

To restore the backup database:

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

  2. Click Start > Run.

  3. Type cmd and then click OK.

  4. On the Windows 2000 command interpreter, execute the following commands:

osql -U {ID} -P {password} -n -Q "RESTORE DATABASE {Control Manager database} FROM DISK = '{path and backup name}'"

For example:

osql -U sa -P -n -Q "RESTORE DATABASE db_ControlManager FROM DISK = 'f:\db.dat_bak'"

A successful database restoration produces a similar result as the following:

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

For more information on how to use osql, refer to the MSDN library.

See also:

Back up db_ControlManager using osql