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

Create a technical support case if you need further support.

Shrinking OfficeScan database and limiting its transaction log to 20GB

    • Updated:
    • 2 Apr 2018
    • Product/Version:
    • OfficeScan 11.0
    • OfficeScan XG.All
    • Platform:
    • Windows 2012 Standard R2
Summary

This article provides details on how to shrink the OfficeScan database and limit its transaction log to 20GB.

Details
Public

To limit the OfficeScan database and save space:

  1. On the OfficeScan server, navigate to Control Panel > Services and stop the OfficeScan Master Service.
  2. Go to the SQL server where the OfficeScan database resides and open SQL Management Studio.
  3. Log in with an account that has permission to view and configure the OfficeScan database. By default, it's hostname-OSCE.
  4. Expand databases on the left side and make a backup of the OfficeScan database:
    1. Right-click on the database.
    2. Choose Tasks > Back Up.
    3. Press Enter.
    4. Choose backup type "Full" and backup component "Database".
    5. Configure the destination.
    6. Click Ok.
  5. To shrink the OfficeScan database and save on space, right-click on hostname-OSCE > Tasks > Shrink > database.
  6. To limit OfficeScan's database transaction log:
    1. Right-click on hostname-OSCE and choose "Properties".
    2. Click Files.
    3. On the right side, scroll to the end and look for hostname-OSCE_Primary.ldf. This is what you will limit. You will NOT limit the .mdf file since that's the OfficeScan data.
    4. Look for a column called autogrowth/Maxsize and click on the gray box with three dots for the .ldf file. A window should pop up.
    5. Enable autogrowth:
      1. Under Maximum File Size, choose "Limited to".
      2. Change the default (2,097,152) to "2,000".
      3. Click Ok.
    6. In the main window, click Ok.
  7. Go back to the OfficeScan server and restart the OfficeScan Master Service.
  8. Log in to the OfficeScan console and go to Logs > Log maintenance.
  9. Review the data and make sure that the database is maintained properly and keep only what you need.
  10. Scroll to the bottom and click Save.
  11. Configure the SQL server to have a scheduled database backup:
    1. Go back to SQL Management Studio and log in with an account that can manage the OfficeScan database. You must be a member of a sysadmin role to create and manage maintenance plans.
    2. On the left side, expand Management and right-click on Maintenance Plans and choose "Maintenance Plan Wizard".

Follow the steps to make a database backup for OfficeScan regularly. If you do not make a backup, the transaction logs will grow and keep more transactions.

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