Add MS SQL Server

When a MS SQL Server is added to the BDRSuite Backup server, a BDRSuite Backup Agent (BBA) is automatically or manually  installed in the target machine.

Procedure to add MS SQL Server

MS SQL Server machine has to be added before you begin configuring the backup schedule. In the Data Sources tab choose ‘ Add Microsoft SQL Server . You will be taken to a page where you will see a message stating ‘No host added’ if you adding host for the first time.

Click on ‘ Add SQL Server ‘ and there are two methods provided on the opening page for adding  which are as follows;

Step 1: Download Backup Agent

Step 2: Backup Agent Installation on Individual Hosts

msiexec /i BDRSuite_Delegation_Service_7_0_0_0.msi /qn BACKUPSERVERINFO=”Enter Backup Server IP Address/DNS Name” SQLBACKUPENABLED=”1″

This option allows you to add each host by entering their IP address and credentials.  This will automatically install Backup Agent on the target host

Add MS SQL Server by providing ‘Hostname/IP Address and its login credentials.

Display Name

Specify a name for the host to identify it on the BDRSuite Backup Server. This name will be used to distinguish the hosts with the same IP Address.

IP Address/DNS Name

Enter the hostname or IP address of the hostname for which you have to proceed with the backup

The Hostname can be added using FQDN(Fully qualified domain name) ie., machine_name.domain_name. You can connect your host with BDRSuite Backup Server through the following combinations in the Hostname/IP Address section:

• Hostname – Enter the Hostname alone
• Hostname@Domain name – Enter the hostname followed by @ and domain name
• Domain name/Hostname – Enter the domain name followed backslash (/) and the hostname
• https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/ 192.xxx.xxx.xxx – Enter the IP address

Credentials

• You can add new credentials or select existing credentials.
• User Name: Enter the username of the specific host
• Password:https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/https://img.vembu.com/guide/img/2023/ The password of the host or IP Address

Enter Backup Data Dump Location

Enter a path to temporarily dump backup data in the database server before initiating the backup. You can customize the dump location for each backup job which can be done during the backup job configuration.

The MS SQL Server will be added to the BDRSuite Backup Server.

Edit

You can select a different credential or add a new credential.

Delete

If you want to remove a particular KVM, click the Delete option. A pop-up window with the message “Are you sure, you want to delete the selected server or host?” will appear. Click Yes, Delete.

Rescan

BDRSuite Backup Server will install the backup agent on the target host if not already installed to establish the connection between the backup server and the backup host.

Report

The Agent information report gives you the stage-wise report of the agent installation, click the Reports icon to view the Machine Name, Version, Installed Time, Status, Remarks. Further, expand it to view the installation start and end time.