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
Application
Supported version
Microsoft SQL Server
Microsoft 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)
MySQL
MySQL 8.1, MySQL 8.0, MySQL 5.7
PSQL
PSQL 15.x, PSQL 14.x, PSQL 13.x, PSQL 13.x
Supported Operating System
Operating System
Supported version
Windows
Windows Server 2022, Windows Server 2019, Windows Server 2016, Windows Server 2012 R2 , Windows Server 2012, Windows 11, Windows 10, Windows 8.1
Linux
Debian 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:
Display Name: Provide a name to identify the host in the BDRSuite Backup Server.
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.
Choose Backup Component: Select the appropriate database server.
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"
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"
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:
Display Name: Provide a name to identify the host in the BDRSuite Backup Server.
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
Choose Backup Component: Select the appropriate database server.
Note: By default, Files And Folders plugin was selected. User can select remaining backups by navigating to respective plugin then clicking on space bar
Database Credentials: Provide the database Server credentials. You need to provide the details like Username, Password, Port, Bin path and Dump path.
Note: 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"
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"
KB ID: 115214 Overview This article outlines the prerequisites for adding Microsoft SQL, MySQL, and PostgreSQL database servers on Windows and Linux environments to BDRSuite for seamless backup and data protection. Supported Environments Application ...
PSQL Server can be backed up using the BDRSuite Backup Server. You can simply add the source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add PostgreSQL Database Server. When a PostgreSQL Database ...
MS SQL Server can be backed up using the BDRSuite Backup Server. You can simply add the MS SQL Host as a Data Source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add MS SQL Server. When a MS SQL Server ...
KB ID: 115900 Challenge A hardware failure or system crash on the BDRSuite Backup Server machine can result in the loss of both the BDRSuite application and its backend database (PostgreSQL server). Solution In case of backup server failure/crash, If ...
Overview BDRSuite's MySQL Backup solution provides reliable protection for your MySQL databases, ensuring secure backups of your critical data. With BDRSuite, you can easily restore your MySQL databases in the event of accidental deletion, data ...