SQL AG backup error : Failed to choose agent for backup type [Transactional log]

Last post 08-08-2018, 8:33 AM by Stg. 8 replies.
Sort Posts: Previous Next
  • SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-07-2018, 11:15 AM

    Hello,

    My AG backups start failing after commvault client upgrade.

    If i run the backups from the physical node they run with no problem.

    When i try to run them form AG i get :

    Description: Failed to choose agent for backup for backup type [Transaction Log], reason [Failed to get AG information. Error returned from COM. Failed to get AG information. Error returned from COM. ]. Source: sql001, Process: SQLBackupMaster  FAiled to get AG information. Error returned form COM

     

    Can anyone help?

    Regards,

    STG

  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-07-2018, 11:33 AM

    Could you provide the SQLBackupMaster log file from the SQL client it launches from?  If you are not sure, it is likely the top SQL server on the properties of the SQL instance.

     

    Are these virtual SQL servers that are also secured using the VSA agent?

  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-07-2018, 1:12 PM

    Hello,

    SQLBackupMaster can be found in attach.

    These are Virtual machines, but theres no VM snapshot configured.

    Thanks,

    STG

  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-08-2018, 5:49 AM

    Also in the CVD log i found:

     

    CsqlDMO::GetAG(8103): -Error-: Failed to get AG information. Error returned from COM. Error : [0x80131513].
    60132 14100 08/08 08:56:51 ###### Error [%s]() - CvSmo2017DllMethod not found: 'Void AppMsg.SQLAvailabilityGroup.set_endpointURL(System.String)'.
    60132 161e0 08/08 08:56:51 ###### checkEventSocket() - setupConnection to EvMgrS...
    60132 161e0 08/08 08:56:51 ###### checkEventSocket() - Socket [0x00000000000016BC]: is eventSocket
     
    Ive already done a repair to the commvault install but problem persists.
    Regards,
    STG
  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-08-2018, 6:08 AM

    This realy seems to be a problem with CvSmo2017DllMethod.

    Does any1 know how to solve this? Could realy use some help here.

     

    Regards,

    STG

  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-08-2018, 6:51 AM

    Stg,

    Can you please let us know if any plugin has been configured? what version is configured?

    Thanks

    SH.

  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-08-2018, 7:05 AM

    SQL Manager plugin is installed. 

    Win2016, SQL Server 2016, Management studio 2016.

    Not sure what plugin version is installed. (how can i check it?)

     

    Commvault version is V11SP11+

    This started happening after last hotfix for SP11 were applied.

     

    Regards,

  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-08-2018, 7:20 AM
    Please perform the operation.
    1. Open CMD with admin rights
    2. Navigate to ‘Base’ folder
    3. Run ‘CvSQLAddinConfig.exe -ra’
    4. Restart the services on client machine.

    Then retry the operation and let us know how it goes.

     

  • Re: SQL AG backup error : Failed to choose agent for backup type [Transactional log]
    Posted: 08-08-2018, 8:33 AM

    Problem solved.

    Thanks,

    STG

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2018 Commvault | All Rights Reserved. | Legal | Privacy Policy