PowerProtect | DDBMA standalone backup of SQL Always On database (AAG) fails
Summary: Data Domain DD Boost for Microsoft Applications (DDBMA) standalone backup of SQL Always On Availability Group (AAG) database fails
Symptoms
Backups appear to run successfully but the stored procedure (master.dbo.emc_run_backup) reports a failure stating the following events:
Error message:
Successfully converted from group id to AG name. 149283:ddbmsqlsv: Start secondary backup job failed. host: <hostname>. error: Setting notification event failed on host: <hostname>. 85942:ddbmsqlsv: Stopping Federated backup - No jobs were started successfully. Unable to complete the federated backup.
Cause
The SQL Server agent job runs under the context of the user associated with the SQL Server Agent service. This user account had all necessary permissions (local admin on SQL server, full Windows Management Instrumentation (WMI) permissions per the Microsoft App Agent guide). The backup also works when run from the SQL Server Management Studio (SSMS) Plugin logged in with this user (associated with the SQL server agent service).
When the backup user is not a local administrator, they lack the required WMI privileges. This explains why backups succeed on the UI that uses the logged-in user's account, but fails in SQL, which uses the SQL service account.
Resolution
Confirm that the user is in the local administrator's group and add the SQL Service Account if needed. Verify Log on as a batch job or Log on as a service privileges, usually granted from local admin status; add manually if absent. If issues remain, restart the SQL service or reboot the server to fully apply local admin privileges.