Prerequisites for Automated Installation of BDRSuite Backup Agent on a Windows Database Server

Prerequisites for Automated Installation of BDRSuite Backup Agent on a Windows Database Server

KB ID: 115212 
Prerequisites:
1. Installation of BDRSuite Backup Agent (BBA):
The BDRSuite Delegation Service (BBA) is a critical component for backup operations on the backup host. It is mandatory to have this service running with the name "BDRSuite Backup Agent (BBA)."
2. Access Privileges for Microsoft Windows:
When adding Windows machines (Backup Host) for backup, ensure that the provided credentials possess one of the following privileges.
  1. Administrator
  2. User with administrator privileges
Note: For Windows Workstations, it's recommended to create a user account with administrator privileges and use its credentials during the backup host addition.
3. Access Privilege in the Backup Server:
In the backup server, ensure that the "BDRSuite Backup Server for Application and DBs" service runs under an administrator user account.
To set this up:
  1. Open the Run window by pressing ‘Win + R’ keys.
  2. Type ‘services.msc’ and click OK.
  3. Right-click on "BDRSuite Backup Server for Virtual Physical Workloads" service, select 'Properties.'
  4. Go to the 'Logon' tab, choose the 'This account' radio button.
  5. Provide the administrator user privilege in the format ".\username" and password, then click OK.
  6. Stop and restart the service to apply the changes.
4. Access to the "Admin$" Folder:
Ensure that the backup server has access to the "Admin$" folder of the backup host.
  1. If accessible, proceed to Prerequisite 5.
  2. If not accessible, follow these steps:
  1. Add an Inbound rule in the backup host to allow Windows Management Instrumentation function through the firewall.
  2. Ensure that services "Server Service" and "Windows Remote Management (WS-management)" are running on the backup host.
5. Access to Windows Management Instrumentation:
Allow remote connections to Windows Management Instrumentation on the backup host through the firewall.
  1. Make sure the "Windows Management Instrumentation" service is running on the backup host.
6. Access to Remote Registry:
  1. Ensure that the "Remote Registry" service is running on the Windows backup host.
7. WBEMTest Verification:
After fulfilling the prerequisites, verify remote connectivity to the backup host from the backup server using WBEMTest:
  1. Open the Run window on the backup server by pressing ‘Win + R’ keys.
  2. Type ‘wbemtest’ and click OK.
  3. Enter "\\IP Address of the backup host\root\cimv2" in the namespace field.
  4. Enter the Username and Password of the backup host in the credential section, then click ‘Connect.’
  5. If any errors occur, recheck the prerequisites.
  6. Upon successful WBEMTest, proceed to add the Windows machine for backup in the backup server.
Supported Environment
ApplicationSupported version
MSSQLSQL Server 2022 - CU7
SQL Server 2019 - CU22
SQL Server 2017 - CU31
SQL Server 2016 (SP3)
SQL Server 2014 (SP3) - CU4
SQL Server 2012 (SP4)
MySQLMySQL 8.1
MySQL 8.0
MySQL 5.7
PSQLPSQL 15.x
PSQL 14.x
PSQL 13.x
PSQL 12.x