Using the Ola Hallengren's DatabaseBackup software on a SQL Server 2016 AG. Trying to use copy-only and tran log backups on secondary node, with Backup Preference set to 'Prefer Secondary'.

Given that Ola's stuff is supposed to be node-aware, do we need code prior to running DatabaseBackup that selects whether the node is primary or secondary?

Currently we have full and tran log backups running on primary node with code in place to only run if node is primary. Secondary node has copy-only and tran logs backups set with code in place to only run if node is secondary.

I'd like to make them both the same; can I set up the code on the primary node to be identical to the secondary now that those backups are working? And do I need the code that determines if the node being run on is primary or secondary?


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.