Backup and Restore

This topic describes how to perform backups and restore the Operations Hub database.

Before you begin

You must have Administrator access.

Procedure

Download the PowerShell scripts for backup, restore, and scheduler.
Unzip the downloaded file to access the scripts and jar files.
Perform an Operations Hub backup.
Restore from an Operations Hub backup.
Schedule a backup of Operations Hub.

Back Up the Operations Hub Database

Before you begin

Refer Backup and Restore.

Procedure

Launch Windows PowerShell, and navigate to the location of the backup script file.
Execute BackUp_OperationsHub.ps1 to perform a backup of the UAA, IQP, and WebHMI database.
The OPERATIONS_HUB_BKP_20211013-120559.zip backup is saved to C:\ProgramData. The filename includes the respective backup's datetime in the YYYYMMDD-HHMMSS format.

Restore the Operations Hub Database

Before you begin

It is recommended to take a backup of your current database before continuing with the restore operation. In case you cancel the restore operation, you can recover your current data from the backup.

Refer Backup and Restore.

Procedure

Log in to the machine where Operations Hub is installed.
Copy the db-intializer.jar of the version you want to restore to this location: \Program_Files\GE\Operations Hub\iqp-tomcat\webapps\site\WEB-INF
Launch Windows PowerShell, and navigate to the location of the restore script file.
Enter the path to the backup zip file, and execute Restore_OperationsHub.ps1 to restore the database.
For example:
```
PS C:\Users\Administrator\Desktop> .\Restore_OperationsHub.ps1 C:\ProgramData\OPERATIONS_HUB_BKP_20211013-120559.zip
```
The database is restored.

Schedule Operations Hub Database Backup

Before you begin

Refer Backup and Restore.

Procedure

Launch Windows PowerShell, and navigate to the location of the backup scheduler script file.
Execute BackupScheduler_OperationsHub.ps1 to schedule a backup.
1. To create a scheduler, enter Create.
2. Enter a name for your backup.
3. Enter a description of your backup.
4. Enter Daily to take a backup every day, or Weekly to backup every week.
5. Enter time in the suggested format to take a daily/weekly backup at the given time.
6. Enter the location of your backup script.
  For example:
```
PS C:\Users\Administrator\Documents\db-backup-restore\Backup_OperationsHub.ps1
```
  A daily/weekly backup is scheduled.
1. To delete a scheduler, enter Delete.
2. Enter the name of the backup for which you want to delete the schedule.
  The daily/weekly schedule for the respective backup is deleted.

Results

The backups are saved to C:\ProgramData.

Troubleshooting:

When you run a .ps1 PowerShell script you might get the following message .ps1 is not digitally signed. The script will not execute on the system.
To fix it you have to run the following command to run Set-ExecutionPolicy and change the Execution Policy setting.
```
Set-ExecutionPolicy -Scope Process -ExecutionPolicy Bypass
```
This command sets the execution policy to bypass for only the current PowerShell session after the window is closed. The next PowerShell session will open running with the default execution policy. ???Bypass??? means nothing is blocked. No warnings, prompts, or messages are displayed.

For LDAP user connectivity, make sure the Active Directory server is accessible to both the servers:
- the server from where we take the data backup
- the server to which we restore the data
If the data restored server cannot access LDAP server, the Invalid Credentials error message appears.