2

Can I have a server acting as secondary replica for two primary servers on an availability group?

Exemplo

If possible, are there some concerns about performance in an async environment? Are listeners going to work that way?

Thanks!

Improve this question
2
  • Do you mean for the same database(s), if so how are there two primaries? If you mean for two different AGs, yes, one instance can be a secondary for two different AGs on two different primaries.
    – Aaron Bertrand
    Commented Jun 1, 2016 at 19:39
  • The primary instances are different, with several databases each.The main goal here is to save money with windows and sql server licenses.
    – Daniel Pelegrini
    Commented Jun 1, 2016 at 19:54

1 Answer 1

Reset to default
1

As I understand your question, the answer is Yes. 1 SQL instance can act as a secondary for multiple Availability Groups. Listeners will point to the appropriate AG. You may have some security concerns to address if the user base of the different AGs is a different set of users...make sure they can't access each other's databases in the case that they are read only, or acting as primary on the DR(Secondary) server. Also, all instances will need to be a part of the same WSFC.

Improve this answer
0

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.