+3Hello experts!
Regarding Commvault backup of SQL Always-On Availability Databases.
If the DBs are doing Asynchronous Mode replication to the DR, is it possible to take separate backups of the DB Instances at the DR to backup targets at the DR?
Hope you can help.
Thanks!
Best answer by Scott Reynolds
Hello
If I am not mistaken Asynchronous mainly just means SQL does not wait for the commit before sending the data to the secondary copy. From a backup/recovery standpoint there is not much change.
If you have SQL AG client configured it will still backup full on primary and secondary copy is still in replicated state meaning so backups will not complete from both DR and primary. You can not backup both primary and secondary at same time.
Note in this setup check your AG backup preference in SQL. If its set to secondary tlog backups will run on that secondary node and possibly pull data over the WAN which may not be preferred. Set to prefer primary if primary replia and MA are in same location.
Hello
If I am not mistaken Asynchronous mainly just means SQL does not wait for the commit before sending the data to the secondary copy. From a backup/recovery standpoint there is not much change.
If you have SQL AG client configured it will still backup full on primary and secondary copy is still in replicated state meaning so backups will not complete from both DR and primary. You can not backup both primary and secondary at same time.
Note in this setup check your AG backup preference in SQL. If its set to secondary tlog backups will run on that secondary node and possibly pull data over the WAN which may not be preferred. Set to prefer primary if primary replia and MA are in same location.
+3Thanks, Scott. But if the secondary copy uses a different backup policy, can individual backups be possible?
How about in synchronous replication, is separate backup allowed?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
