Data Backup and Restoration

This section is common to all the editions of IT360 - Professional Edition, Enterprise Edition (Both Central and Probes) and MSP Edition (Both Central and Probes).

Introduction

This document covers the recommended routine operations carried out by ManageEngine IT360 to backup and restore data for available databases.

Data is the heart of an enterprise and hence it's vital for you to protect it. To do the same, you need to implement a data backup and restore strategy. Backing up of data provides protection against accidental loss of user data, database corruption, hardware failures, and even natural disasters.

Taking a regular back up of the data available in IT360 installations is always recommended, so that in case of any disaster, you can restore the backup versions and bring the product to the operational state, immediately.

The following topics are discussed here:

  1. Backup and Restore Procedure - Microsoft SQL

  2. Backup and Restore Procedure - MySQL

  3. Backup and Restore Procedure - Postgre SQL

Creating Backup and Restore Plan for Different Databases

The backup and restore procedure differs for each of the Microsoft SQL, MySQL and Postgre SQL databases. The steps required are listed below in sections.

1. BACKUP AND RESTORE PROCEDURE - MICROSOFT SQL

For IT360 installed with Microsoft SQL as backend, follow the below steps:

A) Backup:

  1. Stop the IT360 service.

  2. For Data Backup: Use the option available with Microsoft SQL Server Management Studio. In case of Microsoft SQL, you need to take backup of the databases used by various IT360 modules and also the ones used by the add-ons and plugins, if any of them has been enabled.
Sl.No:
Database Name
Professional
Enterprise
MSP
 
Central
Probe
Central
Probe
1
<prefix>AMDB
Y
Y
Y
Y
Y
2
<prefix>OpManagerDB
Y
N
Y
N
Y
3
<prefix>consoledb
Y
Y
Y
Y
Y
4
<prefix>netflow
Y
N
Y
N
Y
5
<prefix>servicedesk
Y
Y
N
Y
N
6
deviceexpert [Configuration Management]
Y
N
Y
N
Y
7
OpstorDB
Y
N
Y
N
Y
8
OputilsDB
Y
N
Y
N
Y

Note: <prefix> is the user-defined value entered during installation, or edited using changeDBServer.bat file.

  1. For Configuration Backup: Execute 'BackupData.bat' script available under '<IT360_Home>\bin\' directory.

B) Restore:

  1. Stop the IT360 service.

  2. For Data Restore: Use the option available with Microsoft SQL Server Management Studio. Here, you need to restore all those databases whichever you have backed up.

  1. For Configuration Restore: Execute the 'RestoreData.bat' script available under the '<IT360_ Home>\bin' directory, with the backup file name as 'argument'. (provide the absolute path of the backup file).

i.e., execute the following in the command prompt: <IT360_Home>\bin>RestoreData.bat <Backup_path>\IT360backup.bak

E.g., <IT360_Home>\bin>RestoreData.bat <IT360_Home>\backup\ IT360backup_SEP12_2013_12_32.bak

Top

2. BACKUP AND RESTORE PROCEDURE - MySQL

For IT360 installed with MySQL as backend, follow the below steps:

A) Important:

  1. Please make sure that you have shutdown the IT360 service, during the backup/restore operation.

  2. In the case of Enterprise & MSP editions, it is always better to perform the backup operation in all the IT360 Servers (i.e. Central and Probes) in your setup, simultaneously. Otherwise, there is a possibility of data mismatch occurance between the Central and Probe components, after restoration.

  3. If you are planning to restore the data in any one of the IT360 components, it is always recommended that you have to restore all the IT360 components using the respective backed up data, taken in step 3.

  4. Time required to take back up of the data and restore it in a setup depends on the actual volume of data (available in the setup) that is to be backed up and restored.

B) Backup/Restore Steps for High Availability - Enabled Setup:

To carry out backup and restore in a High Availability - enabled setup, follow these Steps for High Availablility configuration, edition-wise.

C) Backup/Restore Steps for Normal Setup (With No High Availability):

Backup:

  1. Stop the IT360 service.

  2. Execute the 'BackupData.bat' script available under the '<IT360_Home>\bin' directory to start the data backup. 

  3. Once the backup is over, a directory backup is created under '<IT360_Home>' directory and the backup file
    'IT360backup_DateTimeStamp.bak' is placed under this directory.

Restore:

You can restore the backed up data over a fresh installation of IT360, or over an existing problematic installation. During restoration, the existing tables are dropped, new tables are created, and the data is restored in all the tables.

  1. Stop the IT360 service.

  2. Execute the 'RestoreData.bat' script available under the '<IT360_ Home>\bin' directory, with the backup file name as 'argument'. (provide the absolute path of the backup file).

i.e., execute the following in the command prompt: <IT360_Home>\bin>RestoreData.bat <Backup_path>\IT360backup.bak

E.g., <IT360_Home>\bin>RestoreData.bat <IT360_Home>\backup\ IT360backup_SEP12_2013_12_32.bak

Note: If you are using Windows 2008 Server, the process of executing the Batch file requires 'Edit' permission in IT360 folders (even if you are a user having Administrator privilege). Else, you need to invoke the command prompt with Administrator Privilege [i.e. by right clicking on the 'Command Prompt' icon and selecting 'Run as Administrator' option]. Then, go to the '<IT360>/bin directory' and execute 'backup_mysql.bat/restore_mysql.bat'.

Top

3. BACKUP AND RESTORE PROCEDURE - POSTGRE SQL

For IT360 installed with Postgre SQL as backend, follow the below steps:

A) Important:

  1. Please make sure that you have shutdown the IT360 service, during the backup/restore operation.

  2. In the case of Enterprise & MSP editions, it is always better to perform the backup operation in all the IT360 Servers (i.e. Central and Probes) in your setup, simultaneously. Otherwise, there is a possibility of data mismatch occurance between the Central and Probe components, after restoration.

  3. If you are planning to restore the data in any one of the IT360 components, it is always recommended that you have to restore all the IT360 components using the respective backed up data, taken in step 3.

  4. Time required to take back up of the data and restore it in a setup depends on the actual volume of data (available in the setup) that is to be backed up and restored.

B) Backup:

  1. Stop the IT360 service.

  2. Execute the 'BackupData.bat' script available under the '<IT360_Home>\bin' directory to start the data backup. 

  3. Once the backup is over, a directory backup is created under '<IT360_Home>' directory and the backup file
    'IT360backup_DateTimeStamp.bak' is placed under this directory.

C) Restore:

You can restore the backed up data over a fresh installation of IT360, or over an existing problematic installation. During restoration, the existing tables are dropped, new tables are created, and the data is restored in all the tables.

  1. Stop the IT360 service.

  2. Execute the 'RestoreData.bat' script available under the '<IT360_ Home>\bin' directory, with the backup file name as 'argument'. (provide the absolute path of the backup file).

i.e., execute the following in the command prompt: <IT360_Home>\bin>RestoreData.bat <Backup_path>\IT360backup.bak

E.g., <IT360_Home>\bin>RestoreData.bat <IT360_Home>\backup\ IT360backup_OCT12_2013_12_32.bak

Note: If you are using Windows 2008 Server, the process of executing the Batch file requires 'Edit' permission in IT360 folders (even if you are a user having Administrator privilege). Else, you need to invoke the command prompt with Administrator Privilege [i.e. by right clicking on the 'Command Prompt' icon and selecting 'Run as Administrator' option]. Then, go to the '<IT360>/bin directory' and execute 'backup_mysql.bat/restore_mysql.bat'.

Top



Copyright © 2013, ZOHO Corp. All Rights Reserved.