Can two primary AlwaysOn servers be each other's secondary?
We have a situation where our primary disaster recovery site it also a valid hospital satellite (SQLB) to our main campus hospital (SQLA) in town. The same application (XAPP) is using a local database at each respective site as shown in Figure A.
In theory a disaster "could" occur at each site. So the main campus could be the DR for the satellite site and vice versa. Can AlwaysOn be used to allow each SQL Server to store the other's secondary database/replica? And, even if this is possible, is it a good idea?
Figure A: Can SQLA be the primary for SQLB's databases and vice versa?