Home » Configuring Settings >> Database Backup and Restore
 

Data Back up and Restore

RMM Central stores information like configuration details, status of deployed configurations, and details about reports in a database. Creating a backup of this database and certain important files like configuration files is necessary to prevent loss of data.

You can back up data automatically, by scheduling a back up using RMM Central, or taking a back up manually. You can also restore this data when required. For example, assume that your hard disk crashes and you have to re-install RMM Central. You can use the last back up you took to restore all the required information. Note that this is possible only if the backup file is stored in a computer other than yours.

Best Practises for Back up and restore

These are the few best practices recommended for Back Up and Restore option.

  1. Make sure that you add the exclusion list for Anti Virus. When directories containing the PGSQL data are scanned by anti virus software, they misidentify the files content as spam and does not allow to back up that data. Refer the following links which will guide you, how to exclude the Anti Virus.

    McAffe : https://kc.mcafee.com/corporate/index?page=content&id=KB50998

    Symantec : http://www.symantec.com/business/support/index?page=content&id=TECH99955

    Kaspersky : http://support.kaspersky.com/us/faq/?qid=208284276

  2. It is always recommended to Schedule the back up during non-office hours.
  3. Make sure that you have a minimum of 5GB space to store the back up data.
  4. Make sure that you specify a Valid destination folder.

Scheduling Data Backup (Applicable for Management Component only)

You can use RMM Central to take a back up of the Management component's database regularly. For example, if you want to take a back up of the database every Friday at 5 p.m., you can schedule the same using RMM Central.

To schedule back up of data, follow the steps given below:

  1. Select the Admin tab -> UEM tab

  2. Under Database settings click Database Backup

  3. Specify the time at which you want the back up to be taken, in hour:minute:second (hh:mm:ss) format

    The time should be specified in the 24-hour format. For example, if you want the database back up to be taken at 6 p.m., the time should be specified as 18:00:00.

  1. Select the number of backup files that you want RMM Central to save

    Using this option you can select how many database backup files should be saved. The older backup files will be deleted. For example, if you want only 7 backup files saved, select 7. This will ensure that at all times only 7 backup files are saved.

  2. Specify the location where you want the backup files to be stored

  3. Check the Notify when the database backup fails checkbox

  4. Specify the email address (es) to which you want an e-mail message sent, if the database back up failslease note that you should have configured your mail server settings to get notified.

    Ensure that you have configured your mail server settings to receive notifications.

  5. Click Save Changes

You have scheduled an automatic data backup to take place automatically at a specified time.

Manual Data Backup and Restore (Applicable for both Management and Monitoring components)

You can manually back up and restore the databases of both management and monitoring component.

Steps to Manually Backup and Restore - Management Component

Opening the Backup-Restore Utility Graphical User Interface (GUI)

You can manually back up and restore the Management component using the Backup-Restore Utility GUI.

To open the Backup-Restore Utility GUI, follow the steps given below:

  1. Right click start -->Explore --> directory where Central server folder is present -->ManagementCentral -->bin

  2. For example, right click start -->Explore -->Local Disk (C:) -->Program Files -->RMM_Server -->ManagementCentral -->bin

  3. Double-click backuprestore.bat

You've opened the Backup-Restore Utility GUI.

Creating a backup file

  1. On the Backup-Restore Utility GUI, click the Backup tab

  2. Select the location where you want to save the backup file

  3. Click Backup

  4. You can choose to encrypt the backup file by providing a password.

A backup file is created and saved in the specified location. The file will be named using the buildnumber-date-time.zip format. For example, 70120-Oct-25-2010-13-26.zip where 70120 is the build number, Oct 25th 2010 is the date and 13:26 is the time.

Restoring a backup file

    Ensure that you have shut down the RMM Central server before restoring a backup file.

  1. On the Backup-Restore Utility GUI, click the Restore tab

  2. Browse and select the required backup file.

  3. Click Restore

  4. In case you have opted for encrypting the backup file, you will have to provide the password for restoring the backup.

    The build number of the RMM Central server should match the build number of the backup file you are restoring. Ensure that you choose the correct architecture of the RMM Central installation, such as 32-bit or 64-bit. You can verify the details by viewing the Support tab, on the RMM Central web console.

This will restore the specified Management Component data to  RMM Central server.

Steps to Manually Backup and Restore - Monitoring Component

Data Backup and Restoration - Monitoring Component

RMM Central database contains two types of data:

Performance data: This is the data gathered by RMM Central by periodically polling or querying the resources on a monitored device to determine its performance. This includes resources like CPU, Memory, Response time, Traffic etc.

Configuration data: There are quite a few configurations an administrator effects in RMM Central for easy management and monitoring. The configurations include user settings, details of discovered devices, custom monitors, threshold settings, notification profiles, etc.

Steps to backup data:

  • Open command prompt with administrative privileges and go to <RMM Central Home>/MonitoringCentral/bin/backup directory.
  • Execute BackupDB.bat (use BackupDB.sh for Linux) from the command prompt as shown below:

<RMM Central Home>/MonitoringCentral/bin/backup>BackupDB.bat

Note: This utility does a backup of the complete database, i.e., performance and configuration data. Only the configuration data will be backed up for Netflow Analyzer and Firewall Analyzer modules.

  • The backup file created will be stored in <RMM Central Home>\backup directory. To store the backup file in a different directory, use the command given below:BackupDB.bat -destination "<DestinationFolderPath>" (Eg : BackupDB.bat -destination "C:\Backup")

To backup only the configuration data:

  • Open command prompt with administrative privileges and go to <RMM Central Home>/MonitoringCentral/bin/backup directory and execute the below command:

<RMM Central Home>/bin/backup>BackupDB.bat -mode configdata

  • This is used to backup only the configuration data (Backup Conf., Images folder, the details of Devices, Device Templates, Interfaces, Interface Template, Dashboards & Widgets, Infrastructure Views, Business Views, Credentials, Notification Profiles and Users) and not the performance data.

Steps to restore data:

  • Open command prompt with administrative privileges and go to <RMM Central Home>/MonitoringCentral/bin/backup directory.
  • Execute RestoreDB.bat (use RestoreDB.sh for Linux) with the backup file name as argument from the command prompt as shown below:

<RMM Central Home>/MonitoringCentral/bin/backup>RestoreDB.bat "<Backup file name with path>"
(Eg: RestoreDB.bat "C:\backup\Backup_Pgsql_Mar8_125128_123313.zip" )