Scribd Logo
Upload

Welcome to Scribd!

  • 988 views

    Avamar KB 000471330

    Uploaded by

    jaykkamal
    The SQL client backup was failing with "BACKUP DATABASE permission denied" errors. The cause was that the Backup Agent service account did not have appropriate rights to backup the SQL Server databases. The resolution is to add the Backup Agent service account, reported in the backup log, to the SQL SERVER ROLE "sysadmin" using SQL Server Management Studio.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Avamar KB 000471330

    Uploaded by

    jaykkamal
    988 views1 page
    The SQL client backup was failing with "BACKUP DATABASE permission denied" errors. The cause was that the Backup Agent service account did not have appropriate rights to backup the SQL Server databases. The resolution is to add the Backup Agent service account, reported in the backup log, to the SQL SERVER ROLE "sysadmin" using SQL Server Management Studio.

    Original Description:

    avamar

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The SQL client backup was failing with "BACKUP DATABASE permission denied" errors. The cause was that the Backup Agent service account did not have appropriate rights to backup the SQL Server databases. The resolution is to add the Backup Agent service account, reported in the backup log, to the SQL SERVER ROLE "sysadmin" using SQL Server Management Studio.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    988 views1 page

    Avamar KB 000471330

    Uploaded by

    jaykkamal
    The SQL client backup was failing with "BACKUP DATABASE permission denied" errors. The cause was that the Backup Agent service account did not have appropriate rights to backup the SQL Server databases. The resolution is to add the Backup Agent service account, reported in the backup log, to the SQL SERVER ROLE "sysadmin" using SQL Server Management Studio.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 1

    KNOWLEDGE BASE

    Knowledge Base Article: 000471330


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

    Version: 2 Article Type: Break Fix Audience: Level 30 = Customers Last Published: Sun Feb 21 02:08:42 GMT 2016

    Summary:
    Issue:

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

    2013-12-02 13:04:33 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)
    2013-12-02 13:04:43 avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting
    and the timeout interval had elapsed' (Log #10)
    2013-12-02 13:04:43 avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting
    and the timeout interval had elapsed' (Log #10)
    2013-12-02 13:04:43 avsql Error <6479>: Timed out. Was Microsoft SQLServer running? (Log
    #10)
    2013-12-02 13:04:43 avsql Error <6479>: Timed out. Was Microsoft SQLServer running? (Log
    #10)
    2013-12-02 13:04:48 avtar Info <7202>: Backup CANCELLED, wrapping-up session with Server
    (Log #2)
    2013-12-02 13:04:48 avtar Info <7202>: Backup CANCELLED, wrapping-up session with Server
    (Log #3)
    ...
    2013-12-02 13:04:52 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'.
    2013-12-02 13:04:52 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'.
    ...
    2013-12-02 13:05:10 avsql Error <14272>: There are no successfully finished database
    tasks!
    2013-12-02 13:05:10 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
    backup the SQL Server databases.

    Resolution: Open SQL Server Management studio and make sure that the Backup Agent service account (either local SYSTEM or a
    dedicated backup account) reported in the backup log 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 dialog box, select the Server Roles page.
    6. In the Server roles box, make sure that that sysadmin is checked.

    Product: Avamar, Avamar Plug-in for SQL

    You might also like