Skip to main content
Solved

app aware backup

  • 7 February 2024
  • 3 replies
  • 65 views

Forum|alt.badge.img+15

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

@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 

View original
Did this answer your question?

3 replies

Chris Hollis
Vaulter
Forum|alt.badge.img+15
  • Vaulter
  • 333 replies
  • February 7, 2024

@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 


Forum|alt.badge.img+15
  • Author
  • Byte
  • 151 replies
  • February 8, 2024

@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 ?


Chris Hollis
Vaulter
Forum|alt.badge.img+15
  • Vaulter
  • 333 replies
  • Answer
  • February 8, 2024

@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 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings