Avamar: SQL backup failing with "BACKUP DATABASE permission denied in database" error

Résumé: This knowledge base (KB) article discusses Avamar SQL backups failing due to a permissions issue.

Cet article concerne Cet article ne concerne pas Cet article n’est associé à aucun produit spécifique. Toutes les versions du produit ne sont pas identifiées dans cet article.
Consulter d’autres ressources

Symptômes

The SQL client backup may fail due to the following error messages in the log:
 

avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BACKUP DATABASE permission denied in database 'OperationsManager'.
 (Log #10)
avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting and the timeout interval had elapsed' (Log #10)
avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting and the timeout interval had elapsed' (Log #10)
avsql Error <6479>: Timed out. Was Microsoft SQLServer running? (Log #10)
avsql Error <6479>: Timed out. Was Microsoft SQLServer running? (Log #10)
avtar Info <7202>: Backup CANCELLED, wrapping-up session with Server (Log #2)
avtar Info <7202>: Backup CANCELLED, wrapping-up session with Server (Log #3)
...
avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BACKUP DATABASE permission denied in database 'master'.
avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BACKUP DATABASE permission denied in database 'msdb'.
...
avsql Error <14272>: There are no successfully finished database tasks! 
avsql Error <14294>: An error occurred when generating sql metadata

Cause

The account (local SYSTEM by default) configured for the Backup Agent service does not have appropriate rights to back up the SQL Server databases.

Résolution

Open SQL Server Management studio and verify that the Backup Agent service account is added to SQL SERVER ROLE "sysadmin."
 
To assign SQL Server roles to the Backup Agent service account:
  1. On the SQL client, start SQL Server Management Studio.
  2. In the left pane of the SQL Server Management Studio window, expand the tree to display first the required SQL Server and then the Security folder.
  3. Under the Security folder, click Logins to display the users in the right pane.
  4. In the Logins list, right-click the Account (either NT Authority\SYSTEM or the dedicated backup account), and then click Properties.
  5. In the login properties box, select the Server Roles page.
  6. In the Server roles box, enable the sysadmin role by clicking the checkmark next to it.
  7. Click the OK button to save the changes.

Produits concernés

Avamar, Avamar Plug-in for SQL
Propriétés de l’article
Numéro d’article: 000039635
Type d’article: Solution
Dernière modification: 22 juil. 2025
Version:  4
Trouvez des réponses à vos questions auprès d’autres utilisateurs Dell
Services de support
Vérifiez si votre appareil est couvert par les services de support.