Steps to add Database Server (Microsoft SQL Server/MySQL/PostgreSQL) using Manual installation

Steps to add Database Server (Microsoft SQL Server/MySQL/PostgreSQL) using Manual installation

KB ID: 115213

Overview

This Knowledge Base article provides detailed instructions for adding database servers to the BDRSuite Backup Server, supported platforms, system requirements, and steps for manual and bulk installations. 

Supported Platform

ApplicationSupported version
Microsoft SQL ServerMicrosoft SQL Server 2022 - CU7, Microsoft SQL Server 2019 - CU22, Microsoft SQL Server 2017 - CU31, Microsoft SQL Server 2016 (SP3), Microsoft SQL Server 2014 (SP3) - CU4, Microsoft SQL Server 2012 (SP4)
MySQLMySQL 8.1, MySQL 8.0, MySQL 5.7
PSQLPSQL 15.x, PSQL 14.x, PSQL 13.x, PSQL 13.x

Supported Operating System

Operating SystemSupported version
WindowsWindows Server 2022, Windows Server 2019, Windows Server 2016, Windows Server 2012 R2
, Windows Server 2012, Windows 11, Windows 10, Windows 8.1
LinuxDebian Linux 10.0 & Above, CentOS 7.4 & Above, CloudLinux 7.0 & Above, Fedora 34.0, Red Hat Enterprise Linux v8.0, SUSE Linux Enterprise Server, 12 SP5 & Above,
Ubuntu 18.04 LTS & Above

System Requirements:

Memory:At least 2 GB
CPU:Dual-Core Processor or higher

How to Video

Watch the following video on How to add Windows database server using Manual installation

Microsoft SQL Server (Windows)


MySQL Database Server (Windows)


PostgreSQL Database Server  (Windows)                                                                           

Steps to add Windows database server  (Microsoft SQL Server/MySQL/PostgreSQL) using Manual installation

Step 1: Download Backup Agent

Ensure that you download the appropriate Backup Agent based on your operating system

Step 2: Backup Agent Installation on Individual Backup Hosts

1. Run the backup agent setup file on the target host where you want to install the agent.
2. Follow the on-screen instructions to proceed with the installation.
3. During the installation process, you will be prompted to enter the following information:
  1. Display Name: Provide a name to identify the host in the BDRSuite Backup Server.
  2. Backup Server DNS Name/IP Address: Enter the DNS Name/IP Address of the BDRSuite Backup Server to register the host with the BDRSuite Backup Server.

  1. Choose Backup Component: Select the appropriate database server.

  1. Database Credentials: Provide the database Server credentials. You need to provide the details like Username, Password, Port, Exe path and Dump path.
4. Complete the installation process by providing the necessary information.
5. Upon successful installation, the agent will automatically establish a connection and register the host with the BDRSuite Backup Server.
6. To verify the installation and connection, navigate to the 'Application & DB ->Data Sources' menu on the BDRSuite Backup server. Here, you will find the host details, including the display name, Hostname/IP address, and connection status.

Step 3: Configure Backup

After the host is successfully listed under the Data Sources menu, you can proceed to configure backups. This can be done from the 'Application & DB ->Backup -> Configure Backup' menu within the BDRSuite interface.           

Bulk Installation Steps of Database Servers in Windows:

Bulk Installation of Microsoft SQL Server Backup Agent 

Download the backup agent and install it on multiple backup hosts where SQL Server Database runs simultaneously using the command below through any third-party tool:
Command: msiexec /i BDRSuite_Delegation_Service_7_0_0_0.msi /qn BACKUPSERVERINFO="Enter Backup Server IP Address/DNS Name" SQLBACKUPENABLED="1"
Example: msiexec /i BDRSuite_Delegation_Service_7_0_0_0.msi /qn BACKUPSERVERINFO="192.168.102.161" SQLBACKUPENABLED="1"

Bulk Installation of MYSQL Backup Agent 

Download the backup agent and install it on multiple backup hosts where MySQL Database runs simultaneously using the command below through any third-party tool:
Command: msiexec /i BDRSuite_Delegation_Service_7_0_0_0.msi /qn BACKUPSERVERINFO="Enter Backup Server IP Address/DNS Name" MYSQLBACKUPENABLED="1" MYSQLUSERNAME="Enter MySQL Database Username" MYSQLPASSWORD="Enter MySQL Database Password" MYSQLPORT="Enter MySQL Port" MYSQLEXEPATH="Enter MySQL Server Executable Path" MYSQLDUMPEXEPATH="Enter MySQL Server Dump Executable Path"
Example: MYSQLBACKUPENABLED="1" MYSQLUSERNAME="mysqluser" MYSQLPASSWORD="admin" MYSQLPORT="3306" MYSQLEXEPATH="C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" MYSQLDUMPEXEPATH="C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql_dump.exe"

Bulk Installation of PostgreSQL Backup Agent 

Download the backup agent and install it on multiple backup hosts where PostgreSQL Database runs simultaneously using the command below through any third-party tool:
Command: msiexec /i BDRSuite_Delegation_Service_7_0_0_0.msi /qn BACKUPSERVERINFO="Enter Backup Server IP Address/DNS Name" PSQLBACKUPENABLED="1" PSQLUSERNAME="Enter PostgreSQL Database Username" PSQLPASSWORD="Enter PostgreSQL Database Password" PSQLPORT="Enter PostgreSQL Port" PSQLEXEPATH="Enter PostgreSQL Server Executable Path" PSQLDUMPEXEPATH="Enter PostgreSQL Server Dump Executable Path"
Example: msiexec /i BDRSuite_Delegation_Service_7_0_0_0.msi /qn BACKUPSERVERINFO="192.168.102.161" PSQLBACKUPENABLED="1" PSQLUSERNAME="postgres" PSQLPASSWORD="admin" PSQLPORT="5432" PSQLEXEPATH="C:\Program Files\PostgreSQL\15\bin" PSQLDUMPEXEPATH="C:\Program Files\PostgreSQL\15\bin"

How to Video

Watch the following video on How to add Linux database server using Manual installation

MySQL Database Server (Linux)                                                 

PostgreSQL Database Server (Linux)                                                 

Steps to add Linux Database server  (MySQL/PostgreSQL) using Manual installation

Step1: Download Backup Agent

Ensure that you download the appropriate Backup Agent based on your operating system

Step 2: Backup Agent Installation on Individual Backup Hosts

1. Run the backup agent setup file on the target host where you want to install the agent.
2. Follow the on-screen instructions to proceed with the installation.
3. During the installation process, you will be prompted to enter the following information:
  1. Display Name: Provide a name to identify the host in the BDRSuite Backup Server.
  2. Backup Server DNS Name/IP Address: Enter the DNS Name/IP Address of the BDRSuite Backup Server to register the host with the BDRSuite Backup Server
  3. Choose Backup Component: Select the appropriate database server.
            We were unable to process some of the images.
Note: By default, Files And Folders plugin was selected. User can select remaining backups by navigating to respective plugin then clicking on space bar
  1. Database Credentials: Provide the database Server credentials. You need to provide the details like Username, Password, Port, Bin path and Dump path.
NotesNote: The default values for the selected Database server Port, Application Bin Path, and Application Dump Path are automatically loaded on this screen, and the user can modify them as required.
4. Complete the installation process by providing the necessary information.
5. Upon successful installation, the agent will automatically establish a connection and register the host with the BDRSuite Backup Server.
6. To verify the installation and connection, navigate to the Application & DB ->Data Sources menu on the BDRSuite Backup Server. Here, you will find the host details, including the display name, Hostname/IP address, and connection status.

Step 3: Configure Backup

After the host is successfully listed under the Data Sources menu, you can proceed to configure backups. This can be done from the 'Application & DB ->Backup ->Configure Backup' menu within the BDRSuite interface.          

Bulk Installation Steps of Database Servers in Linux:    

Bulk Installation of MySQL Backup Agent 

Download the backup agent and install it on multiple backup hosts where the MySQL Database is running simultaneously using the following command through any third-party tool:
Command: bash BDRSuite_Delegation_Service_7_0_0_0_RH.bin --BACKUPSERVERINFO "Enter Backup Server IP Address/DNS Name" --MYSQLBACKUPENABLED "1" --MYSQLUSERNAME "Enter MySQL Database Username" --MYSQLPASSWORD "Enter MySQL Database Password" --MYSQLPORT "Enter MySQL Port" --MYSQLEXEPATH "Enter MySQL Server Executable Path" --MYSQLDUMPEXEPATH "Enter MySQL Server Dump Executable Path"
Example: bash BDRSuite_Delegation_Service_7_0_0_0_RH.bin --BACKUPSERVERINFO "192.168.102.161" --MYSQLBACKUPENABLED "1" --MYSQLUSERNAME "root" --MYSQLPASSWORD "admin" --MYSQLPORT "3306" --MYSQLEXEPATH "/usr/bin/" --MYSQLDUMPEXEPATH "/usr/bin/"

Bulk Installation of PostgreSQL Backup Agent 

Download the backup agent and install it on multiple backup hosts where the PostgreSQL Database is running simultaneously using the following command through any third-party tool:
Command: bash BDRSuite_Delegation_Service_7_0_0_0_RH.bin --BACKUPSERVERINFO "Enter Backup Server IP Address/DNS Name" --PSQLBACKUPENABLED "1" --PSQLUSERNAME "Enter PostgreSQL Database Username" --PSQLPASSWORD "Enter PostgreSQL Database Password" --PSQLPORT "Enter PostgreSQL Port" --PSQLEXEPATH "Enter PostgreSQL Server Executable Path" --PSQLDUMPEXEPATH "Enter PostgreSQL Server Dump Executable Path"
Example: bash BDRSuite_Delegation_Service_7_0_0_0_RH.bin --BACKUPSERVERINFO "192.168.102.161" --PSQLBACKUPENABLED "1" --PSQLUSERNAME "postgres" --PSQLPASSWORD "Vembu123$" --PSQLPORT "5432" --PSQLEXEPATH "/usr/bin/psql.bin" --PSQLDUMPEXEPATH "/usr/bin/pg_dump.bin"