Learn how to properly back up and restore the TMMS 9.0 server.
Download the TMMS Backup and Restore tool to do the following:
The following terms will be used in this article:
- Source Server (Source Management Server): The management server to back up
- Target Server (Target Management Server): The management server to restore the settings
- Source Database Server: The database server used by the source management server
- Target Database Server: The database server used by the target management server
You may use the following tips in using the tool:
- For Exchange Connector, you need to download installation package from the web console and install it after restoration.
- This tool supports backup and restore between the same versions of management servers.
- This tool does NOT back up the configurations of Local Communication Server (LCS). If LCS is used, it will still be used by the target management server after restoration.
- After restoration, all configurations are persisted; all devices remain managed. There is no need to reenroll any device.
The backup files include:
- Database backup file – This is the backup of the database used by the source management server. By default, the backup file is under the database server's c:\bak.
- Configuration backup files - These are the backup of the configuration files on the source management server. By default, the backup file is under backup & restore tool folder.
Back up the Source Management Server
To back up the database and configurations:
- Download the the TMMS Backup and Restore tool on the machine where the source management server is installed.
- Run Backup_and_Restore.
- On the tool’s UI, go to the Backup Current Data section.
- Select 9.0 on the Version dropdown list. The installation path will automatically be shown in the Installation Path field.
- Set the backup path for the database:
- Log on to the machine where the database server is installed.
- Create a new folder for the database backup, for example, C:\bak.
This will be used as the backup path for the database file.
- Go back to the Backup and Restore tool and enter the backup path in the Database Path field.
Click the Backup button.
When the backup is finished, all the configuration files will be stored in the [Backup_and_Restore_Tool_Folder]\bak. For example, C:\Backup_and_Restore\bak directory.
The database backup file will be stored in the path you specified in Step 5.
- The bak folder will be created automatically in the same path as theBackup_and_Restore.exe file.
- Do not change the name of the database backup file. Otherwise, the restoration will fail.
Copy the backup files to the target management server
You need to copy the backup files to the machine where the target management server will be installed.
The following explains the two kinds of backup files:
Database backup files
If you use a different database server for the target management server, you need to manually copy the database backup file to the machine where the target database server is installed.
There is no need to copy the database file if you will use the same database server for the source and target management servers.
Configuration backup files
If you try to restore the old settings to the same management server (i.e. the source management server is also the target management server), there is no need to copy the configuration files. Otherwise, do the following:
- Copy the folder containing the Backup and Restore tool to the machine where the target management server is installed.
- Copy the folder [Backup_and_Restore_Tool_Folder]\bak (for example, C:\Backup_and_Restore\bak) from the source management server, and put it to the folder containing the tool on the target management server.
If the target server is not the source server, you need install the target server before doing the restoration. Refer to the Installation and Deployment Guide for detailed installation instructions.
Before restoration, make sure the source management server is stopped or uninstalled.
To restore the database and configuration:
- Run the TMMS Backup and Restore tool on the machine where the target management server is installed.
- Go to the Restore Data section and select 9.0 from the Version dropdown. The installation path will be shown in the Installation Path field.
- Select one configuration file path you have backed up. The folder name contains the timestamp.
- In the Database Path field, do one the following:
- If you use the same database server as the source server, enter the path where you saved the backup file.
- If you use a different database server from the source server, enter the path on the target database server where you had copied the backup file. This was done in Database and Configuration Backup.
- Click the Restore button. When the restoration is complete, the result will prompt.
If the restoration fails, check the logs in the tool folder to get detailed information.
- After restoration, check the Configuration and Verification page to validate the settings.
- If the target management server is different from the source server, make sure the source management server is uninstalled or stopped after the restoration. Otherwise, both the two management servers may manage the devices at the same time.
- Try to remote lock a device on the management web console to simply check whether the devices can be managed.
Q: Before doing restoration, do we need to copy any files from the source server?
A: Yes. You need to copy the following files:
- Database backup file
- Configuration backup files
Q: Can we restore from TMMS server using SQL Server 2008 to TMMS server using SQL Server 2005?
A: No. Trend Micro recommends using the same version of database server for the source and target management servers. If you use different versions, make sure that the database backup files can be restored between the two versions.