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

Create a technical support case if you need further support.

Migrating OfficeScan (OSCE) server database to an SQL Server

    • Updated:
    • 17 Oct 2016
    • Product/Version:
    • OfficeScan 10.6
    • OfficeScan 11.0
    • OfficeScan XG.All
    • Platform:
    • Windows 2003 Enterprise
    • Windows 2003 Standard
    • Windows 2008 Enterprise
    • Windows 2008 Standard
Summary

The OfficeScan server uses an internal database to store OfficeScan client configuration, logs, and information. In certain environments, centralized database storage may be required, which involves a full-blown relational database server, such as Microsoft SQL Server.

You want to know if it is possible to migrate the OfficeScan internal database to a full-blown SQL database server.

Details
Public

Reasons why to consider SQL migration

By default, OfficeScan 11.0 uses Codebase (same as the previous versions) to store OfficeScan agent configuration, logs, and information. This is recommended for small to mid-sized deployments in maintaining an all-in-one OfficeScan server to minimize the cost and administrative efforts. Using or migrating to SQL database should be considered due to the following reasons:

  • Higher reliability, security, and performance is required.
  • Database corruption issues may occur when using Codebase database.
  • You can take advantage of SQL database backups such as full backups and incremental backups.
  • There is a necessity to have a centralized database for multiple OfficeScan servers that can be managed by the SQL DB administrator.
     
    Each OfficeScan server will be using one instance inside the SQL database.

Migrating to SQL server

To move the contents of the OSCE database to SQL server:

 
Before making any changes, back up the HTTPDB database folder from one local disk to another. Follow this article: Disaster Recovery-Files to back up before upgrading, migrating, or uninstalling the OfficeScan server.

If you want to move from one SQL server to another SQL server using the sqltxfr tool, the bulkadmin, dbcreate, and db_owner roles are the minimum required permissions.

Additional details about SQL server post-migration

After migration, the dbcreator permission can be removed from the account privilege. However, the following permissions should be retained:

  • bulkadmin - This handles the log transfer from OSCE server to SQL database. Without this permission, importing the client logs to the SQL database will fail.
  • db_owner - This allows OfficeScan to modify the tables within the database.

In addition, the user roles below should be kept in the account privilege. Removing these user roles causes OfficeScan Master server to fail.

  • logon as a service
  • logon as a batch job
  • domain admin

When you change the account name or password after the SQL database migration, you can update the account credentials using the Switching to an existing database option from the SQLtxfr.exe tool. This tool will help you modify the account credentials even when the account name and password are already encrypted in a configuration file.

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