Solved

app aware backup

  • 7 February 2024
  • 3 replies
  • 34 views

Userlevel 1
Badge +13

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 

icon

Best answer by Chris Hollis 8 February 2024, 05:52

View original

3 replies

Userlevel 6
Badge +15

@Ajal 

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
 

Log Truncation

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 

Userlevel 1
Badge +13

@Chris Hollis  thank you , is there any process do i need to follow if  i want to do vm and app backup separately for the VM’s app aware is selected, other than changing the app aware backup option from the backup method  .

 

@Chris Hollis  for sql , db and logs will be using same storage policy right  ,will the extended retention also get applied for logs ?

Userlevel 6
Badge +15

@Ajal 

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 

Reply