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
Solved! Go to 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.
Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?
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.
Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?
so it does not work with alwayson (standard/basic) because of the second database?
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.
Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?
thank yo cdinet
Regards
Robert
Corporate Headquarters
6220 America Center Drive
San Jose, CA 95002 USA