Microsoft SQL Server - Adding Data Source

Microsoft SQL Server - Adding Data Source

The data sources tab will list the various environment that you can backup and by selecting which you can enter the host details that you like to backup will be added and then listed for you to proceed with the further configuration.  Also, you can add and manage the credentials of VMs/hosts or the object storage repositories. Once you set up the data sources, you can configure multiple backup jobs for the pre-added host and choose from the pre-added repository to store the backup data based on your requirements.

Add MS SQL Server

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 is added to the BDRSuite Backup server, a BDRSuite Backup Agent (BBA) is automatically or manually  installed in the target MS SQL Host.

Procedure to add MS SQL Server

  1. MS SQL Server 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.
  2. Click on ‘Add SQL Server‘ and there are two methods provided on the opening page for adding which are as follows;
    1. Manual Agent Installation
    2. Automatic Agent Installation

1. Manual Agent Installation

Step 1: Download Backup Agent

Download the appropriate Backup agent from the BDRSuite Backup Server 

Step 2: Backup Agent Installation on Individual Hosts

  1. Run the downloaded Backup Agent setup file on the target MS SQL Host and follow the on-screen instructions to proceed with the installation.
  2. During the installation, you will be prompted to enter the following information:
  1. Display Name: Enter a name to identify the host in the backup server.
  1. Backup Server DNS Name/IP Address: Enter the BDRSuite Backup Server DNS Name/IP Address to register the MS SQL Host with the backup server.
  2. Choose Backup Component: Select the option ‘Microsoft SQL Server Backup’.
  1. Complete the installation process by providing the necessary information.
  2. Once the installation is successful, the agent will automatically establish connection and register the MS SQL Host with the backup server.
  3. To verify the installation and connection, go to the Data Sources menu on the BDRSuite Backup Server. You will see the MS SQL Host details, including Hostname/IP address and connection status.

Bulk Installation of Backup Agent

Download backup agent and install it on multiple backup hosts (where the SQL Server Database runs) simultaneously using the command below through any third party tool.
msiexec /i BDRSuite_Delegation_Service_7_0_0_1_U1.msi /qn BACKUPSERVERINFO=”Enter Backup Server IP Address/DNS Name” SQLBACKUPENABLED=”1″ 

2. Automatic Agent Installation

This option allows you to add each MS SQL Host by entering their IP address and its credentials.  This will automatically install Backup Agent on the target MS SQL Host
Add MS SQL Server by providing ‘Hostname/IP Address and its login credentials.
Notes
Note: You can add as many MS SQL Servers into the BDRSuite Backup Server whenever required   

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 any of the following combinations in the Hostname/IP Address section:
  1. Hostname – Enter the Hostname alone
  2. Hostname@Domain name – Enter the hostname followed by @ and domain name
  3. Domain name/Hostname – Enter the domain name followed backslash (/) and the hostname
  4. 192.xxx.xxx.xxx – Enter the IP address
Notes
Note: If you have provided an invalid Hostname/IP address, the following alert message will be displayed “Unable to connect the MS SQL Server. Please check network connection settings”

Credentials

  1. You can add new MS SQL Credentials or select the existing MS SQL Credentials.
  2. User Name: Enter the username of the specific MSSQL Host.
  3. Password: The password of the MS SQL Host or its 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.
Ensure that your storage has ample space allocated for the dump, in accordance to the size of the data intended for backup. Subsequent to the completion of the backup, the dump will be removed.
After entering the necessary MS SQL Host details, select the ‘Save’ option to initiate a pop-up prompting confirmation. Proceed by clicking on ‘Confirm,’ and the MS SQL Host will be successfully added to the BDRSuite Backup Server.

Edit

You can make changes to all the added details of the MS SQL Host using this ‘Edit’ option. The Display Name/DNS Name, the credentials and the dump location can be modified.

Delete

If you want to remove a particular MS SQL Host, 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

Executing the rescan option allows you to establish a successful connection between the BDRSuite Backup Server and the MS SQL Host, in case of any interruption that caused the connection failure.

Report

Click on the ‘Reports’ icon to view the Machine Name, Version, Installed Time, Status, Remarks. Further, expand it to view the installation start and end time.
Notes
Note: To obtain a stage-wise report of the agent installation, you can monitor the process in real-time. Under the ‘Status’ tab, you’ll find a ‘Progress’ icon and clicking on this icon will show you the stage-wise details, providing insights into the ongoing installation procedure.


    • Related Articles

    • Microsoft 365 - Adding Data Sources

      In order to set up the Data Sources environment, you need to add your Microsoft 365 Organization, which can be done by navigating to the Data Sources -> Add Microsoft 365 Organization. Add Microsoft 365 Organization To add the Microsoft 365 domain, ...

    • Add MS SQL Server

      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 ...

    • Microsoft SQL Server Recovery

      Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...

    • Microsoft SQL Server Recovery

      Microsoft SQL Server Recovery can be performed directly from the BDRSuite Backup Server. The recovery can be performed at a granular level. . You can click on the Recovery tab in the BDRSuite Backup Servers home screen and select Restore Backup Data. ...

    • How to Backup and restore Microsoft SQL Server

      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 ...