Preventing the Worry-Free Business Security (WFBS) database from getting corrupted repeatedly

To resolve the issue:

1. Make sure that the HTTPDB folder is not being backed up by any third party backup software, for this may cause the database to be corrupted. Use the database backup feature of WFBS and point the third party software to back up the backup copy instead.
   For the database backup settings, refer to this article: Changing the settings for the database backup of Worry-Free Business Security (WFBS).
    

   The weekly database backup during Sundays at 5:00AM is the recommended database backup setting.
2. Enable Virus Log Deletion.
   1. Open the WFBS console.
   2. Go to Reports > Maintenance.
   3. Go to the Auto Log Deletion tab.
   4. Set Delete Logs Older Than to "14 Days" for all Log Types.
   5. Click Save.
3. Enlarge the database cache.
   1. Go to the ..\Trend Micro\Security Server\PCCSRV folder.
   2. Open the ofcscan.ini file with a text editor like Notepad.
   3. Under the [INI_DBFILE_SECTION], look for the "DB_MEM_OPT_MAX" and change the default value "10240(KB)" to 10% of the Security Server's free memory.

      Formula:

      Free Memory (GB) x 1000MB x 1024KB = Free Memory (KB) x 0.10 (10%)

      -------- --------

      1GB 1MB

      Example: For a Security Server that has a 4GB free memory:

      [INI_DBFILE_SECTION]

      DB_MEM_OPT_MAX = 409600

   4. Save the changes.
4. Enlarge the command handler's thread number.
   1. In the ..\Trend Micro\Security Server\PCCSRV\ ofcscan.ini file, look for the [INI_SERVER_SECTION] and add a "Command_Handler_Maxium_Thread_Number" entry.
       

      The "Command_Handler_Maxium_Thread_Number" entry does not exist by default. Depending on the number of CPUs, set the value of this entry to 20 times the number of the Security Server's CPU.

      Example: For a Security Server that has 4 CPUs, the value of "Command_Handler_Maxium_Thread_Number" should be 80 (as 4 CPUs x 20 = 80).

      [INI_SERVER_SECTION] Command_Handler_Maxium_Thread_Number=80

       

      It is "Maxium" NOT "Maximum".
   2. Save the changes.
5. Restart the Trend Micro Security Server Master Service.