SQL Question: Basic Availability Groups

[rokasporch]

Regarding the KB https://kc.mcafee.com/corporate/index?page=content&id=KB83860 , there are a question:

We want to use SQL Standard Edition and with SQL Standard edition you get Basic Availability Groups.

Basic = one group for each database that you have ePO has two databases, so two groups to have failover for both databases you need two IPs, one for each group/database..

So ePO must be able to connect to the first DB with one IP and to the second DB with another IP.

The question is really: can ePO work with Basic Availability Groups, which implies using two SQL IPs, one for each DB?

Thanks

Robert

[cdinet]

No, it cannot.  The second database is for storage and efficiency, epo does not connect to that events database directly, as there is a linked synonym for it. 

[rokasporch]

so it does not work with alwayson (standard/basic) because of the second database?

[cdinet · Accepted solution]

I am no sql expert on how exactly the always on feature works in regards to the synonym events database goes.  I do know we do support that feature, but not during upgrades or installs.  So the fact that we do support it, you would need to get with your dba for exactly how that would work with a linked database.

[rokasporch]

thank yo cdinet

Regards

Robert