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

Create a technical support case if you need further support.

Managing the OfficeScan HTTPDB file size

    • Updated:
    • 21 Apr 2016
    • Product/Version:
    • OfficeScan 10.6
    • Platform:
    • Windows 2000 Advanced Server
    • Windows 2000 Professional
    • Windows 2000 Server
    • Windows 2003 Enterprise
    • Windows 2003 Enterprise 64-bit
    • Windows 2003 Standard
    • Windows 2003 Standard 64-bit
    • Windows 2008 Enterprise
    • Windows 2008 Server Core
    • Windows 2008 Standard
    • Windows 2012 Enterprise
    • Windows 2012 Web Server Edition
    • Windows 7 32-bit
    • Windows 7 64-bit
    • Windows 8 32-bit
    • Windows 8 64-bit
    • Windows Vista 32-bit
    • Windows Vista 64-bit
    • Windows XP Home
    • Windows XP Professional
Summary

We use CodeBase database (HTTPDB) as the OfficeScan database. The table shows the three (3) file types in HTTPDB with their description and maximum size limit.

File typeDescriptionMaximum size limit
(with large file support turned off)
CDX (index file)Stores database indices4GB
DBF (data file)Stores information such as client, status, and log information1,000,000,000 bytes records per table
FPT (memo file)Stores memos like system events logs4GB

If the CDX file which stores index information exceeds the 4GB limitation, it will be corrupted and the file size will be reset to “0”. The data location links will be deleted, so the CDX files will not be able to link to the correct records in the DBF and FPT files. Thus, logs will not be displayed.

The database files directory on the OfficeScan server is %systemdrive%\Program Files\Trend Micro\OfficeScan\PCCSRV\HTTPDB.

Details
Public

To prevent HTTPDB from exceeding the file size limit, here are some suggestions to properly manage the OfficeScan database:

Regularly back up the database

By default, the scheduled database backup feature is enabled. Configure this by doing the following:

  1. Log in to the OfficeScan web console.
  2. Go to Administration > Database Backup.
  3. In the Database Backup Schedule section, make sure the Enable scheduled database backup is ticked.
  4. Choose from the following backup plans depending on the environment and requirement:
    • Daily
    • Weekly
    • Monthly

Regularly delete old logs

The database log deletion schedule is also enabled by default. Configure this by doing the following:

  1. Log in to the OfficeScan web console.
  2. Go to Logs > Log Maintenance.
  3. Make sure Enable scheduled deletion of logs is ticked.
  4. In the Log Types to Delete section, choose the logs to be deleted.
  5. In the Logs to Delete section, define how many days to keep the logs.
  6. In the Log Deletion Schedule section, define the desired deletion plan.

Regularly check the database backup files

This is to make sure that the files are available. The database backup files directory is %systemdrive%\Program Files\Trend Micro\OfficeScan\DBBackup\.

Premium
Internal
Rating:
Category:
Configure
Solution Id:
1102419
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.