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).

The following topics are discussed here:

1. Backup and Restore of Data in IT360 Installation with Microsoft SQL as Backend Database

1. Backup

2. Restore

2. Backup and Restore of Data in IT360 Installation with MySQL as Backend Database

   1. Important

   2. Backup/Restore Steps for High Availability - Enabled Setup

   3. Backup/Restore Steps for Normal Setup (With No High Availability)

1. Backup and Restore of Data in IT360 Installation with Microsoft SQL as Backend Database

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

A) Backup:

1. Stop the IT360 service, in which you would like to take a backup.

2. For Data Backup: Use the option available with the Microsoft SQL Server Management Studio.

3. For Configuration Backup: Execute 'Backup_Mysql.bat' script available under '<IT360_Home>/bin/ directory'.

B) Restore:

1. First, stop the IT360 service, in which you would like to restore the data.

2. For Data Restore: Use the option available with the Microsoft SQL Server Management Studio.

   1. For Configuration Restore: Execute 'Restore_Mysql.bat' script available under '<IT360_ Home>/bin/ directory', with the backup file name as 'argument' (provide the absolute path of the backup file). Now, run the command prompt and execute: '<IT360_Home>\bin>Restore_Mysql.bat <Backup_path>\IT360backup.bak'

2. Backup and Restore of Data in IT360 Installation with MySQL as Backend Database

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 software to the operational state, immediately.

A) Important:

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

2. In the case of IT360 Enterprise Edition & MSP Edition, 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, in which you would like to take a backup.
   

2. Execute 'Backup_Mysql.bat' script available under '<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 in this directory.
   

Restore:

1. 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.

2. First, stop the IT360 service, in which you would like to restore the data.
   

3. Execute 'Restore_Mysql.bat' script available under '<IT360_ Home>/bin/ directory', with the backup file name as 'argument' (provide the absolute path of the backup file). Now, run the command prompt and execute: '<IT360_Home>\bin>Restore_Mysql.bat <Backup_path>\IT360backup.bak'