I am trying to understand the capabilities/limitations of geo-replication and Failover groups in Azure with respect to Alwayson AG feature of On premise SQL Sever ENT edition.
I tried setting up geo-replication from Standard to Basic database and it is not permitted. My question is, what happens to GR or secondary database if I need to scale up (say Basic to Standard )my primary database during maintenance?
Does the above mentioned scenarios also applicable to Failover groups like primary and secondary DBs should be of same service tier? If yes then what happens during scale up of database service?
I would be charged for 1 hour for higher service tier even if I downgrade my DBs within few minutes)? I meant I have Basic DB, I upgrade it to Standard and again scale down to Basic within 15 minutes.
Does geo-replication validates the data in secondary database before being configured ? Let's say I configured GR from Server1/testdb to Server2/testdb, here testdb is newly created on Server2. Then Broke the GR and make some data changes in Server2/testdb and then set up GR again in rom Server1/testdb to Server2/testdb. (sorry, I couldn't test that)
Appreciate your insightful response. Thank you.