Restoring 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.

  1. Stop Control Manager.
  2. Click Start > Programs > Administrative Tools > Services to open the Services screen.
  3. Right-click <Control Manager service>, and then click Stop.
  4. Click Start > Run.
  5. Type cmd and then click OK.
  6. On the Command prompt, 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 result similar to the following:

  7. Click Start > Programs > Administrative Tools > Services to open the Services screen.
  8. Right-click <Control Manager service>, and then click Restart.
  9. Start Control Manager. For more information on how to use osql, refer to the MSDN library.