The DBA role fell into my lap and now I was asked to investigate Always On Availability Groups.
So, in the Availability Group environment, do all servers need to have the same specifications? Say I have Server A with a 20 core enterprise environment, do servers B & C have to have 20 Core each?
How does Disaster Recovery work? Currently I have a mirror to an offsite with a decent connection, do I have to up the connection bandwidth? Is the DR site part of the Availability Group? I was under the impression (probably 100% wrong), that if the db is in recovery mode, not accessible, you don’t have to pay for the SQL Server licenses. Now with Always On sounds like you are forced to get the licenses even if you are not accessing the server.
Using Availability Groups, can I create a primary server for one group and set a different primary server for another AG, is that possible?