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

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

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.

Affected Products

PowerProtect App Direct, PowerProtect Software
Article Properties
Article Number: 000192006
Article Type: Solution
Last Modified: 07 Oct 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.