Error Code: "30:385] Description: Failed to choose agent for backup for backup type eTransaction Log], reason nFailed to update AG information of MSSQLAGInstance. ]. Source: hsapsqldb9, Process: SQLBackupMaster
tried to restart the services on the cluster members - didn’t help
Page 1 / 1
Hi Eldan,
Are the AG Nodes the same SP/MR level as the CommServe?
Best Regards,
Michael
Hi Michael, sorry but i’m not familiar with the SP/ MR abbreviations ;)
My apologies! - SP = Service Pack, which has been replaced by FR (Feature Release) and MR = Maintenance Release which replaced HotFix Pack (HPK).
I would suggest to ensure the AG Nodes are the same Commvault Software Level as the CommServe.
yes, the nodes and the software are at the same level
Hi Eldan,
Can you check the SQLBackupMaster.log for any errors on server hsapsqldb9 for this Job? The log Files are usually located at: <Install Drive>:\Program Files\Commvault\ContentStore\Log Files\
Best Regards,
Michael
@MichaelCapon I don’t see any meaningful information
40556 1f98 08/02 15:53:02 3390473 SQLBackupController::FetchAGFromRemoteAgentAndUpdateCS(531): -Debug-: Got AG infromation from replica iHSAPSQLDB9\IPD].
40556 1f98 08/02 15:53:03 3390473 SQLBackupController::FetchAGFromRemoteAgentAndUpdateCS(579): -Error-: Failed to update AG information of MSSQLAGInstance with error h-1].
40556 1f98 08/02 15:53:03 3390473 SQLBackupController::MarkJobStatusFailed(187): -Debug-: JOB STATUS FAIL.
May be best to raise a support case to check this out as there may be a number of things that cause this.
Out of curiosity, are you able to confirm if this was a working AG and it’s now problematic or is this a new setup?
If you view the properties of the AG, do the either of the replicas have an _1 appended to their name?
E.G.
It was working and now problematic
I don’t have the underscore+number added
@Eldan , can you raise a support case and share the number here?
Hey @Eldan , following up to see if you managed to raise a case for this issue. If you did, please share the number so I can track it accordingly
Thanks!
Gentle follow up, @Eldan. I don’t see any support case in your name, so please advise if you have a case number, or were able to get this resolved.
Thanks!
Hi, it’s not relevant right now. the instance was moved back to the original node and the backup is running
I’m sorry we couldn’t help…..is this something you expect to retry soon as o we can try and get to the bottom of it for you?
Hi @Eldan
May be best to raise a support case to check this out as there may be a number of things that cause this.
Out of curiosity, are you able to confirm if this was a working AG and it’s now problematic or is this a new setup?
If you view the properties of the AG, do the either of the replicas have an _1 appended to their name?
E.G.
Hi, I am also facing similar issue and _1 is visible for both the replicas.
Please let me know what should be done here.
Hi, I am also facing similar issue and _1 is visible for both the replicas.
Please let me know what should be done here.
Hello Neelam - Are you able to provide log cuts from the SQLBackupMaster.log from your environment?
Can you check the SQLBackupMaster.log for any errors on server r your SQL Server ] for this Job? The log Files are usually located at: <Install Drive>:\Program Files\Commvault\ContentStore\Log Files\
@Neelam Jain Ideally we would need to check those logs also to see if and what is returned before we are able to determine the issue. Knowing that you are seeing the _1 clients also is helpful but we would still like to confirm in more detail the issue before making assumptions on the resolution.
It also may be best to open a support incident so a member of the support staff can view full logging to narrow this down further.