Dear Experts,
We have 2 SQL Servers which are in AAG, there are some data bases in standalone and some in AAG.
I have configured both the servers using the SQL Always on Feature, the Draw back for TDP for SQL is it doesn't take a Legacy Backup on Primary replica.
The Replica of Primary and secondary changes on daily basis, If i have configured from Secondary server the replica of secondary server will become primary and the backup fails.
Let me know how can i handle this situation, I am totally confused.
We have 2 SQL Servers which are in AAG, there are some data bases in standalone and some in AAG.
I have configured both the servers using the SQL Always on Feature, the Draw back for TDP for SQL is it doesn't take a Legacy Backup on Primary replica.
The Replica of Primary and secondary changes on daily basis, If i have configured from Secondary server the replica of secondary server will become primary and the backup fails.
Let me know how can i handle this situation, I am totally confused.