Few more questions on geo-replication and Failover groups on Azure SQL database

anil kumar 1,641 Reputation points
2021-02-07T12:11:02.117+00:00

Hello,

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.

  1. 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?
  2. 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?
  3. 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.
  4. 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.

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. anil kumar 1,641 Reputation points
    2021-02-08T10:10:13.383+00:00

    Hello,

    Got the answer for 1st and 2nd point - we need to upgrade both GR databases and Failover groups databases before scaling up the primary database.

    GR setup

    Failed to scale from Basic: 2 GB storage to Standard S0: 10 DTUs, 2 GB storage for database: testdb.
    Error code: .
    Error message: The source database 'ak.testdb' cannot have higher edition than the target database 'ak3.testdb'. Upgrade the edition on the target before upgrading source.

    FG setup
    Failed to scale from Basic: 2 GB storage to Standard S0: 10 DTUs, 2 GB storage for database: testdb.
    Error code: .
    Error message: The source database 'ak.testdb' cannot have higher edition than the target database 'ak5.testdb'. Upgrade the edition on the target before upgrading source.


0 additional answers

Sort by: Most helpful