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

Create a technical support case if you need further support.

Configuring Control Manager (TMCM) to ensure that it will not consume all free disk space on the SQL server

    • Updated:
    • 26 Mar 2018
    • Product/Version:
    • Control Manager 6.0
    • Control Manager 7.0
    • Platform:
    • Windows 2012 Standard R2
Summary

When there is no more free disk space in the SQL server database, the TMCM server will not function properly. You can see symptoms such as:

  • Cannot view logs, it might log you out of console
  • Database connection failure errors
  • Inconsistent data displayed on the console that keeps changing

This article helps you ensure that the TMCM server will not occupy all of the free disk space in the SQL server database.

Details
Public

To make sure that the TMCM server will not consume all the free disk space, do the following:

  1. Free disk space in the SQL server. Follow the steps below:
    1. In the TMCM server, go to Start > Control Panel > Services, then stop the Trend Micro Control Manager service.
    2. Go to the SQL server, then Add space to the SQL server if it is virtual, or delete any files that you can.
    3. For TMCM, can go to ..\Trend Micro\Control Manager\AU_Data and delete the folder called AU_Data, which is a temporary folder for updates.
  2. Login to the SQL Management Studio using an account that has permission to view and configure the TMCM database (db_ControlManager).
  3. Make a backup of the TMCM database. Do the steps below:
    1. Right click on db_ControlManager.
    2. Choose Tasks > Back Up, then press Enter.
    3. Choose Backup component: database, the configure the destination.
    4. Click OK.
  4. Shrink the TMCM database to save on space. Either of the following steps can be used to shrink the database:
    • Right-click on db_ControlManager > Tasks > Shrink > database.
    • From the SQL Management Studio, highlight db_controlmanager then click on New Query. Copy and paste the commands below and then click on Execute Query:

      use db_ControlManager
      go
      alter database db_ControlManager set recovery simple
      go
      dbcc shrinkfile('db_ControlManager_log',10000)
      go
      alter database db_ControlManager set recovery FULL
      go

    • Limit the transaction log of the TMCM database. Do the following:
      1. Right-click on db_ControlManager and choose Properties.
      2. Click on Files, then on the right pane, scroll to the end and look for the db_ControlManager_log.ldf.
      3. Look for a column called Autogrowth / Maxsize, then click on the gray box with three dots for the ldf file.
      4. Enable autogrowth, then under maximum file size, choose "limited to" and change the default (2,097,152) to 2,000.
      5. Click OK twice.
  5. Go back to TMCM server, and restart the TMCM service.
  6. Login to the TMCM console and go to Logs > Log maintenance. Review these so that you can make sure the database is maintained properly and you only keep what you need. Then scroll to bottom and click save.
  7. Configure the SQL server to have a scheduled database backup. Do the following:
    1. Login to the SQL management studio using an account that can manage the TMCM database.
       
      You must be a member of sysadmin role to create and manage maintenance plans.
    2. On the left side, expand Management, then right-click on Maintenance Plans > Maintenace Plan Wizard.
    3. Follow the steps to make a database backup for TMCM regularly. If you do not make a backup, the transaction logs will grow and keep more transactions.
Premium
Internal
Rating:
Category:
Troubleshoot
Solution Id:
1119557
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.