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.
- From the Control Manager server, click Start > Run.
- Type cmd and then click OK.
- 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).
