Views:

To resolve the issue, follow these steps based on your product version:

  1. Apply OfficeScan XG SP1 Critical Patch 4406.

  2. Stop the following Services:

    • Trend Micro Apex Central Service
    • Trend Micro Management Infrastructure Service
    • World Wide Web Publishing Service
  3. Open SQL Management Studio then connect to the Apex Central™ Database Server.
  4. Select the Apex Central™ Database. The default name is <db_ApexCentral>.

  5. Start a New Query, then execute the following script:

    truncate table tb_statuslogjournalPLS

    update tb_journalcheckpoint set bigwatermark=0 where name='tb_statuslogjournalPLS'
    update tb_journalcheckpoint set watermark=0 where name='tb_statuslogjournalPLS'

    dbcc shrinkdatabase('db_ApexCentral')

     
    Replace “db_ApexCentral” with your Apex Central™ database name.

  6. Start the following Services:

    • Trend Micro Management Infrastructure Services
    • Trend Micro Apex Central Service
    • World Wide Web Publishing Service
  7. Log on to the Apex Central™ console then go to Directories > Products.
  8. On the Product Tree, select the Officescan XG SP1.

  9. Click Task then click Synchronize OfficeScan Clients and Domains.

    All Status will be synchronized later.

  1. Apply OfficeScan XG SP1 Critical Patch 4406.

  2. Stop the following TMCM Services:

    • Trend Micro Control Manager Service
    • Trend Micro Management Infrastructure Service
    • World Wide Web Publishing Service
  3. Open SQL Management Studio then connect to the TMCM Database Server.
  4. Select the TMCM Database. The default name is <db_ControlManager>.

  5. Start a New Query then execute the following script:

    truncate table tb_statuslogjournalPLS

    update tb_journalcheckpoint set bigwatermark=0 where name='tb_statuslogjournalPLS'
    update tb_journalcheckpoint set watermark=0 where name='tb_statuslogjournalPLS'

    dbcc shrinkdatabase('db_ControlManager')

     
    Replace “db_ControlManager” with your TMCM database name.

  6. Start the following TMCM Services:

    • Trend Micro Management Infrastructure Services
    • Trend Micro Control Manager Service
    • World Wide Web Publishing Service
  7. Log on to the TMCM console then go to Directories > Products.
  8. On the Product Tree, select the Officescan XG SP1.

  9. Click Task then click Synchronize OfficeScan Clients and Domains.

    All Status will be synchronized later.

  1. Apply Officescan XG SP1 Critical Patch 4406.

  2. Stop the following TMCM Services:

    • Trend Micro Control Manager Service
    • Trend Micro Management Infrastructure Service
    • Trend Micro Common CGI Service
    • World Wide Web Publishing Service
  3. Open SQL Management Studio then connect to the TMCM Database Server.
  4. Select the TMCM Database. The default name is <db_ControlManager>.

  5. Start a New Query then execute the following script:

    truncate table tb_statuslogjournalPLS

    update tb_journalcheckpoint set bigwatermark=0 where name='tb_statuslogjournalPLS'
    update tb_journalcheckpoint set watermark=0 where name='tb_statuslogjournalPLS'

    dbcc shrinkdatabase('db_ControlManager')

    Replace “db_ControlManager” with your TMCM database name
  6. Start the following TMCM Services:
    • Trend Micro Management Infrastructure Services
    • Trend Micro Control Manager Service
    • Trend Micro Common CGI Service
    • World Wide Web Publishing Service
  7. Log on to the TMCM console then go to Directories > Products.
  8. On the Product Tree, select Officescan XG SP1.

  9. Click Task then click Synchronize OfficeScan Clients and Domains.

    All Status will be synchronized later.

Keywords: rapid increase in DB size,unexpected DB size growth,database rapid growth,control manager DB growing rapidly,troubleshoot increasing DB,solution rapid DB increase,solution rapid database increase