App-Aware VM Backup Schedules

Hi @Tom Evans 

If I’m understanding you right, what you’re saying is that the subclient within the SQL Instance itself has inherited the same scheduler as the VSA Subclient containing the VM?

If so, that does not sound right… I’d only expect to see a T-LOG backup schedule be automatically assigned (at the SQL subclient) which is mentioned here: https://documentation.commvault.com/commvault/v11_sp20/article?p=14283.htm

There is a possibility that the SQL Agent was added to a client group that defines the same scheduler as the VSA subclient. 

Do you have smart groups configured by any chance? 

Please refer to: 

https://documentation.commvault.com/commvault/v11_sp20/article?p=4874.htm & https://documentation.commvault.com/commvault/v11_sp20/article?p=4894.htm
 

Could you please check to see if the SQL client is part of multiple or any other client computer groups? 

Hi @Chris Hollis 

Thanks for your reply.

Yep the issue is exactly as you describe in that the SQL Instance has inherited schedules from the plan configured for the VSA backup.

The SQL client is part of 4 groups in total (all default configuration). The hypervisor group, External Clients for Failover, Infrastructure and MediaAgents group.

I've checked schedules for these groups and the only schedule is the Automatically created Install Software schedule.

No smart groups configured in the environment (other than default system created ones).

Thanks
Tom

Thanks for clarifying @Tom Evans 

I think it would be best to see if we can get a copy of your database and review this via a support incident as I don’t believe what you are seeing is expected (it could be...but we’ll confirm officially once we’ve reviewed the setup).

Would you be able to raise a support case and let me know the ticket number? 

We’ll loop back on this thread with our findings afterward for the broader community. 

@Chris Hollis,

I raised this with support a few days ago so is actively being worked on, I posted on here in case anyone might have had a similar issue and could possibly advise the fix at the time.

Initial response from support is that it is not expected behaviour. 

Once I have a resolution I will update this post.

Hi Tom! I’m having exact same issue (two CommCells, both 11.22). As a workaround I removed SQL associations from plan’s schedule policies in Commcell Console. Let us know your findings from support.

Updating the thread as it seems that dev provided a diag for @Tom Evans .  Definitely curious to see the end result!

Hi @Mike Struening 

The diag was for a separate issue regarding the configuration of the User for AppAware backups from the Command Center. Effectively when applying the user it wasn’t actually doing anything so when the AppAware backup ran the job would fail because it didn't have sufficient permissions.

I am still awaiting further information on the schedules issue.

Thanks

Tom

Thanks for the continued updates, @Tom Evans !

@Tom Evans , gentle follow up to see if the update has worked.  Once you confirm, I’ll track down the eventual public fix for everyone else to follow.

Hi @Mike Struening ,

The diag that support provided me has worked and new AppAware backups no longer inherit the schedules from the plan.

Thanks

Tom

Sweet, thanks for confirming.  Great news before the weekend!!