Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

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

    • Updated:
    • 5 Apr 2016
    • Product/Version:
    • Worry-Free Business Security Standard/Advanced 7.0
    • Worry-Free Business Security Standard/Advanced 8.0
    • Worry-Free Business Security Standard/Advanced 9.0
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Small Business Server
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Essential Business Server
    • Windows 2008 Small Business Server
    • Windows 2008 Standard
    • Windows 2011 Small Business Server Essentials
    • Windows 2011 Small Business Server Standard
Summary

This article shows you what to do when the Worry-Free Business Security (WFBS) database repeatedly gets corrupted.

Details
Public

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.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot
Solution Id:
1059474
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.


Need More Help?

Create a technical support case if you need further support.