Avamar：SQL 備份失敗，並出現「BACKUP DATABASE permission denied in database」錯誤

Summary: 本知識庫 （KB） 文章討論 Avamar SQL 備份因權限問題而失敗的問題。

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.
Check out other resources

Symptoms

SQL 用戶端備份可能會因記錄中出現下列錯誤訊息而失敗：
 

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

為備份代理服務配置的帳戶（預設情況下為本地 SYSTEM）沒有備份 SQL Server 資料庫的適當許可權。

Resolution

開啟 SQL Server Management Studio ，並確認備份代理程式服務帳戶已新增至 SQL Server 角色「sysadmin」。
 
若要將 SQL Server 角色分配給備份代理服務帳戶，請執行以下操作：
  1. 在 SQL 用戶端上，啟動 SQL Server Management Studio。
  2. 在 SQL Server Management Studio 視窗的左窗格中，展開樹狀結構以首先顯示所需的 SQL Server，然後顯示 安全性 資料夾。
  3. 在 安全性 資料夾下，按一下 登入 ，在右窗格中顯示使用者。
  4. 在 “登錄 名”列表中，右鍵單擊 該帳戶 （NT Authority\SYSTEM 或專用備份帳戶），然後按兩下 “屬性”。
  5. 在登入內容方塊中，選取 伺服器角色 頁面。
  6. 在 伺服器 角色方塊中，按一下旁邊的核取記號以啟用 sysadmin 角色。
  7. 按一下確定按鈕以儲存變更。

Affected Products

Avamar, Avamar Plug-in for SQL

Products

Avamar
Article Properties
Article Number: 000039635
Article Type: Solution
Last Modified: 22 Jul 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.