Re: Vembu BDR sesrver got crashed..

Hi Vaibhav ,

Thank you for reaching out our Vembu Community Forum.

A hardware failure or a system crash in the machine running the Vembu BDR backup server may lead to a loss of the Vembu BDR application and its PostGres back-end server installations. However, the backup data might still be intact if the storage was in a separate storage device. In that case, it is possible to rebuild the Vembu BDR backup server completely provided the backup data and the database dump file are intact in the backup storage location.

In re-building a Vembu BDR backup server, you need to have the following:

1. Backup storage targets which holds backup data (i.e., sgstorage folder from all backup data storage drives attached earlier).When more than one drive is configured for storage, make sure you have all of them.For example, when E and H drives are configured as storage drives,then make sure you have both E:\sgstorage, H:\sgstorage .
2. ‘Plugin-data’, ‘data’ and ‘conf’ folders (Taken from ‘VembuBDR-Home’ which typically will be C:\Program Files\Vembu\VembuBDR).

3. Dumped Server Configuration Database file

   By default, the Vembu BDR backup server’s configurations are stored in a database that is dumped daily. This file is dumped under the path given during installation for the backup storage location. For e.g.
   E:\sgstorage\Default_Repo\SGDatabase.sql

Steps to Rebuild Backup Server

Rebuilding the backup server is a two-step process:

1. Installation of Vembu BDR and PostGres database.
2. Importing of Vembu BDR backup server database

Installation of Vembu BDR and PostGres database.

1. Download BDR server installer from Vembu Downloads and make sure the version is same as Vembu BDR running earlier

2. Run the installer with administrator privileges. Note: Once installation completes, make sure Vembu BDR service is NOT started. If started, then stop the service.

   Open ‘Vembu BDR-Home’ location and replace the following sub-folders with the sub-folders copied earlier : ‘data’, ‘Plugin-data’ and ‘conf’

3. Now make sure you configure the same drive letters for storage location and avail in same location as configured earlier. Say like same E and H drive as mentioned in earlier steps.

Importing of Vembu BDR backup server database

1) Open CMD prompt with administrator privileges and run below command from PostgreSQL installation location to create the database " SGDatabase"

a) psql -Upostgres
It will ask for postgres password and after entering the password execute the below command to create database

b) create Database SGDatabase

2) Now exit from postgres terminal and run the below command to import the database psql -Upostgres SGDatabase <dumpfile location="" ex:="" psql="" -upostgres="" sgdatabase="" &lt;="" f:\sgstorage\default_repo\sgdatabase.sql<="" p="">

It will ask for postgres password and after entering the password check the import process. After importing the databases please start Vembu BDR service and ensure the backups are resumed and running successfully.

Note : By default, the Vembu BDR backup server’s configurations are stored in a database that is dumped daily.So the backup details after the last dump time will not be populated.