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.
- Administrator
- 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:
- Open the Run window by pressing ‘Win + R’ keys.
- Type ‘services.msc’ and click OK.
- Right-click on "BDRSuite Backup Server for Virtual Physical Workloads" service, select 'Properties.'
- Go to the 'Logon' tab, choose the 'This account' radio button.
- Provide the administrator user privilege in the format ".\username" and password, then click OK.
- 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.
- If accessible, proceed to Prerequisite 5.
- If not accessible, follow these steps:
- Add an Inbound rule in the backup host to allow Windows Management Instrumentation function through the firewall.
- 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.
- Make sure the "Windows Management Instrumentation" service is running on the backup host.
6. Access to Remote Registry:
- 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:
- Open the Run window on the backup server by pressing ‘Win + R’ keys.
- Type ‘wbemtest’ and click OK.
- Enter "\\IP Address of the backup host\root\cimv2" in the namespace field.
- Enter the Username and Password of the backup host in the credential section, then click ‘Connect.’
- If any errors occur, recheck the prerequisites.
- Upon successful WBEMTest, proceed to add the Windows machine for backup in the backup server.
Supported Environment
Application | Supported version |
MSSQL | SQL Server 2022 - CU7 |
SQL Server 2019 - CU22 |
SQL Server 2017 - CU31 |
SQL Server 2016 (SP3) |
SQL Server 2014 (SP3) - CU4 |
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 12.x |