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 XG
- 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
- 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.
- If the OfficeScan Server and SQL server are on installed the same production machine, there are some specific points to consider:
- The OfficeScan server recommended memory size is 2 GB. Please refer to the System Requirements documents from Trend Micro: OfficeScan.
- The SQL Server recommended memory size is 4GB, thus the recommended memory size for the machine should be 6GB or higher. Please refer to the following article from Microsoft: Hardware and Software Requirements for Installing SQL Server 2008.
- How to set a fixed amount of memory in the SQL Server, please refer Microsoft's instructions found in the following article: How to: Set a Fixed Amount of Memory (SQL Server Management Studio).
-
Turn off Auto-Shrink.
Click image to enlarge