can we schedule separate backup for application only which is part of app aware backup ,
like , vsa with app aware - once in a day and application every two hours
Best answer by Chris Hollis
View originalcan we schedule separate backup for application only which is part of app aware backup ,
like , vsa with app aware - once in a day and application every two hours
Best answer by Chris Hollis
View original
No, the application is protected via the VM, so management of the data is always from the VSA VM and not the agent.
Out or curiosity, what application requires backup every 2 hours?
For various agents that are configured with AppAware, we automatically create a schedule to trigger backups (such as SQL T-LOGS).
Please refer to: https://documentation.commvault.com/2023e/expert/microsoft_sql_server_requirements_for_application_aware_backups.html
For Microsoft SQL Server, an automatic log backup schedule is created automatically after you run an application-aware backup successfully for the first time.
https://documentation.commvault.com/2023e/expert/performing_application_aware_backup.html
If you needed to, you could modify this automatic schedule to run a transaction log based backup more frequently if necessary.
If you are talking about another agent, let me know.
Regards,
Chris
Query 1: Disable AppAware on the VSA Subclent and then disable IntelliSnap on the application client subclient. configure your subclients content/policies and schedules for both indepdently/as required.
Query 2 part 1: VSA Subclient Storage policy and SQL DB (data) will be the same policy. This is mentioned here.
https://documentation.commvault.com/2023e/expert/microsoft_sql_server_requirements_for_application_aware_backups.html
Query 2 part 2:
This article states: https://documentation.commvault.com/2023e/expert/excluding_applications_from_application_aware_backups.html mentions that you can leverage this key: https://documentation.commvault.com/additionalsetting/details?name=SkipStoragePolicyAssocForTLBackup
This additional setting can be used in cases where the user wants to associate transaction log backups with a storage policy of their choice.
So you can define a separate policy for your logs, just not the ‘data’ (database) portion of SQL.
Yes, extended retention configured for the policies defined will be applied (so if you had the VM subclient storage policy and T-LOG policies writing to the same policy, the extended retention would apply to both the VM backups and the SQL log backups). Note however that LOG backups have their own configuration paremeters (as logs are tied to a data job, if that data job has extended retention, the logs will be retained as they are required_by_job).
Have a read of this article which highlights this: https://documentation.commvault.com/2023e/expert/sql_server_agent_data_aging.html
Any questions let me know.
Regards,
Chris
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.