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

Create a technical support case if you need further support.

Recommended SQL server configuration for OfficeScan (OSCE)

    • Updated:
    • 21 Sep 2016
    • Product/Version:
    • OfficeScan 11.0
    • OfficeScan 12.0
    • Platform:
    • Windows 2008 Enterprise
    • Windows 2008 Enterprise 64-bit
    • Windows 2008 Standard
    • Windows 2012 Enterprise R2
    • Windows 2012 Server R2
    • Windows 2012 Standard
    • Windows 2016 Server Standard
Summary

This article introduces the following information about SQL for Trend Micro OfficeScan (OSCE):

  • Supported SQL versions
  • Migration to SQL server
  • Recommend configurations
Details
Public

Supported SQL Server Versions

  • OfficeScan 11.0
    • 2008 R2 Express SP2
    • 2008
    • 2008 R2
    • 2012
  • OfficeScan 11.0 SP1
    • 2008 R2 Express SP2
    • 2008
    • 2008 R2
    • 2012
    • 2014
  • OfficeScan 12.0
    • 2008 R2 Express SP2
    • 2008
    • 2008 R2
    • 2012
    • 2014
    • 2016

Migrating OfficeScan (OSCE) Server Database to an SQL Server

Please refer to the following KB article: Migrating OfficeScan (OSCE) server database to an SQL Server.

Migrating a local SQL Database to a Remote SQL Server Database from OfficeScan (OSCE)

Please refer to the following KB article: Migrating a local SQL database to a remote SQL server database from OfficeScan (OSCE) 11.0.

Recommended SQL server configuration for OfficeScan server

  1. Use Microsoft SQL Server Standard or Enterprise Edition. SQL Express edition should only be used for testing and is not recommended for a production environment.
  2. If the OfficeScan Server and SQL server are on installed the same production machine, there are some specific points to consider:
  3. Turn off Auto-Shrink.

    auto-shrink

    Click image to enlarge

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