Skip to main content
commvault.com commvault.com

we are having windows always on HA sql cluster , currently we are taking fileand app consitent vm backup and seperatly agent based sql backup .

 

now we need to make DR for this in our azure site 

which is the better option 

!> VM replication , do i need to change the vm backup method to app aware ? in this case only primary node will be converted as app aware right ? i dont want to run the vm backup every 2 hour , instead i need to run log backup , can i just schedule log backup for same client  will this get replicated once the log backup completed ?

 

2 > warm sql replicaton 

 

which one is recommended way 

​@Ajal The methods used really depend on the specific needs for the organization.

If you are just concerned about the SQL databases best method is to just Live Sync for MSSQL.
https://documentation.commvault.com/2024e/essential/configuring_replication_for_sql_database_01.html

This ensures that the SQL dbs are consistent.

 

​@Scott Reynolds  thank you, for this we need to have an resrouce up and running at azure and which is a cost for us .

i was planning to do a app aaware backup of SQL primary VM and then replicate it as warm replication 

now my question does the log backup also triggers the rplication or only the whole vm backup ?

​@Ajal you can replicate the vm but I think the issue is the SQL database. When running just transaction log backups on the source without some form of SQL sync those will not get replicated.

 

​@Scott Reynolds  what if am creating orchestrated replication where whever there is a backup it wil replicate,

i will create vm group , change it to app aware, create plan with log schedule every 30 minute and vm backup once every day

 

so does the database log job get replicates?

No for appaware the full backup is a vss snapshot of the database. Log backups are regular transaction log backups via SQL API so those tlog backups will not get replicated even is using appaware.

Reply


Terms & ConditionsCookie settings