You can fix a database corruption by frequently flushing data in memory to the disk. It is available on the following versions of OfficeScan:
- OfficeScan 10 SP1 Patch 4 or above
- OfficeScan 10.5 Patch 4
- OfficeScan 10.6 SP1
To schedule and configure a database flush task, do the following:
- Open the ofcscan.ini file in the ...\PCCSRV\ folder of the OfficeScan server.
- Under the INI_DBFILE_SECTION section, locate the following keys and assign the appropriate values:
[INI_DBFILE_SECTION]
DB_IDLE_PERIOD={x} (Default value:900)
DB_ENFORCE_DBFLUSH_PERIOD={y} (Default value:7200)Where:
"x" is a value from 300 to 86400 seconds, it is the amount of time after the database process becomes idle when the flush task should run. By default, the flush task will run when the database process has been idle for 15 minutes.
"y" is a value from 300 to 86400 seconds, it is the frequency of the flush process. By default, the database process runs the flush task every two hours after the latest flush. - Save the changes made to the ofcscan.ini file and close the it.
- Restart the OfficeScan Master Service.
You can also enable the database service to trigger the database backup task as the service starts:
- Open the ofcscan.ini file in the ...\PCCSRV\ folder of the OfficeScan server.
- Under the INI_DBFILE_SECTION section, locate the following key and set an appropriate value:
[INI_DBFILE_SECTION]
DB_BACKUP_PRE_TASK=0( =0 - database backup task will not be triggered (Default), =1 - database backup task will be triggered )
The database backup file is saved in the ...\DBBackup\ folder of the OfficeScan server and is named using the Backup_YYYYMMDDHHMMSS format. - Save the changes and close the file.