+7Hi All,
We have database configured in Availability Group and we have configured backup in Commvault with availability group name. Is it possible to run to run Full and Differential and Tlog backup from Secondary node.
We have selected the prefer backup option as secondary are as Secondary Node in SQL Studio Management but as per my thinking only tlog will run from secondary Node.
Please let me can Commvault run all backups from Secondary Node of Availability Group.
If yes how to configure it.
Best answer by Orazan
Good morning. Full and Differential backups will always run from the primary replica.
You can run the following backups on the primary and secondary replica:
Full and differential backups: These backups always run on the primary replica.
Transaction log backups: If the primary replica is set as the preferred replica for running backups, then transaction log backups run on the primary replica. Otherwise, the transaction log backups run on the secondary replica that has the highest backup priority.
This is a SQL limitation.
https://support.microsoft.com/en-us/topic/kb4551221-fix-error-occurs-when-you-try-to-create-a-differential-backup-on-secondary-replica-in-sql-server-a9720cc3-7445-17eb-bd62-d8868197788b#:~:text=Note%20Currently%2C%20SQL%20Server%20does,allowed%20on%20a%20secondary%20replica.
Note Currently, SQL Server does not allow differential backup on a secondary replica because it can’t modify the differential bitmap page. This is because the database is read-only.
Good morning. Full and Differential backups will always run from the primary replica.
You can run the following backups on the primary and secondary replica:
Full and differential backups: These backups always run on the primary replica.
Transaction log backups: If the primary replica is set as the preferred replica for running backups, then transaction log backups run on the primary replica. Otherwise, the transaction log backups run on the secondary replica that has the highest backup priority.
This is a SQL limitation.
https://support.microsoft.com/en-us/topic/kb4551221-fix-error-occurs-when-you-try-to-create-a-differential-backup-on-secondary-replica-in-sql-server-a9720cc3-7445-17eb-bd62-d8868197788b#:~:text=Note%20Currently%2C%20SQL%20Server%20does,allowed%20on%20a%20secondary%20replica.
Note Currently, SQL Server does not allow differential backup on a secondary replica because it can’t modify the differential bitmap page. This is because the database is read-only.
Note you can run a full backup from the secondary node if you run a copy-only backup. (This is only valid for fulls not diffs)
Full copy only and transaction log backups run either on the primary replica, if the primary replica is set as the preferred replica for running backups, or on the secondary replica with the highest backup priority.
Must enable the backup option after selecting full
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
