I have two nodes A & B, I'm trying to set Node A to be primary for DB1 with Node B as its secondary and then set up Node B as primary for DB2 and Node A as its secondary. (I'm using SQL 14.0.1000.169)
Do I need two Availability groups, two listeners, two failover clusters? Currently I have one of each.
I was able to successfully create the Availability group for the first scenario but now I'm lost.