If you’re decomissioning a SQL server, you might need to migrate the Trend Micro Intrusion Defense Firewall (IDF) database. To migrate the Trend Micro Intrusion Defense Firewall (IDF) database:
- Log onto the OfficeScan server that has the IDF plugin installed
- Navigate to C:\Program Files (x86)\Trend Micro\OfficeScan\Addon\Intrusion Defense Firewall\webclient\webapps\ROOT\WEB-INF
- Open dsm.properties in Notepad
- The following records tell you the name of the database that you want to migrate:
database.name=<>
database.SqlServer.instance=<>
database.SqlServer.server=<>
- Stop the Intrusion Defense Firewall service
- Backup or dettach and copy the IDF database that you want to migrate from the SQL server instance
- Restore or attach the IDF database to the SQL server you want to migrate to
- On the OfficeScan server that has the IDF plugin installed, edit the dsm.properties file to point to the SQL server instance that you are migrating to
- Start the Intrusion Defense Firewall service
- Check that the IDF plugin works