Question About DatabaseBackup Proc #444
-
|
DatabaseBackup Proc: We have Always On Enabled and are taking backups on Primary node. We are not explicitly setting the @copyonly to “Y” in our secondary node sql backup job. It’s just taking the default value in the stored procedure as “N”. Will you advise us to include the @copyonly parameter to “Y” in the secondary node or does it automatically know that it’s the secondary node and it’s supposed to ignore taking backups on secondary?
|
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
@Nehamnsu, if you prefer to perform your backups on the primary replica, then you don't need to specify I have some information about backup of availability groups in the Frequently Asked Questions: |
Beta Was this translation helpful? Give feedback.
-
|
thank you |
Beta Was this translation helpful? Give feedback.
@Nehamnsu, if you prefer to perform your backups on the primary replica, then you don't need to specify
@CopyOnly = 'Y'.I have some information about backup of availability groups in the Frequently Asked Questions:
"How should I configure DatabaseBackup to back up an Availability Group?"
https://ola.hallengren.com/frequently-asked-questions.html