Backing Up db_ControlManager Using osql

If the Control Manager database is corrupted or non-functional, use a backup copy to restore your settings. When using MSDE, use the MSDE command line interface — osql, to generate a database backup.

  1. From the Control Manager server, click Start > Run.
  2. Type cmd and then click OK.
  3. On the Command prompt, execute the following commands:

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

    Where:

    {ID}: user name of the administrator account used to access the Control Manager database. This is defined during Control Manager setup.

    {password}: password used to access the Control Manager database. This is defined during Control Manager setup.

    {Control Manager database}: name of the Control Manager database

    {path and backup name}: target location and the backup file name

    For example:

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

    A successful database backup produces a result similar to the following:

    If the backup file db.dat_bak already exists, the command osql inserts new records into the existing file to back up new information.

    Note:

    Trend Micro recommends backing up the Control Manager database regularly. Always back up when you are about to modify the Control Manager database (for example, installing a managed product).