0

i have 4 nodes. 2 nodes in sync mode, 2 nodes in asyn mode. Can i relocate all backup jobs (full, tlog) on any secondary? does the backup truncate the transaction log on primary?

1 Answer 1

1

Can i relocate all backup jobs (full, tlog) on any secondary?

You can, however as of now only copy_only full backups are supported on secondary replicas. Also, if the secondary replica is behind, for example an async replica that has a send queue, then it can only back up the portion of the log that it has.

does the backup truncate the transaction log on primary?

Log backups taken on a secondary replica will allow log truncation on a primary replica if it meets the normal criteria for log truncation.

1
  • 1
    And note that if you only take COPY_ONLY full backups, you can't really use differential backups, as the differential base will never be reset. Commented Aug 24, 2023 at 20:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.