SQL Safe allows you to configure backup policies with availability groups. The policy includes all the databases in the Availability Group that you want to backup and you can determine which Availability Group members you would like to be taken into account.

Keep in mind that in Availability Groups:

  • On primary replicas you can perform full, differential, and log backups.
  • On secondary replicas, full backups must be copy only, differential backups are not supported, and log backups must NOT be copy only.

When SQL Safe performs the backup operation, it detects the preferred replica for the backup operation and it skips the non-preferred ones.

Please take into account that if you add a new node as the preferred replica and it is not part of the policy, you will need to add the respective database to the policy. 



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal
  • No labels