question

anilkumar-3187 avatar image
0 Votes"
anilkumar-3187 asked ·

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

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
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

anilkumar-3187 avatar image
0 Votes"
anilkumar-3187 answered ·

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.


· 5 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,

Got the answer for 4th point.

If database with same name already exists on secondary server wile setting up GR, you need to first delete that database from secondary before setting up GR for your primary database.

I think this logic sounds good for smaller databases but for bigger database, it may take some time before GR is set is up. Still better to avoid schema and data validation....

0 Votes 0 ·

@anilkumar-3187

We are checking this and we will get back to you.

Regards
Navtej S

0 Votes 0 ·

@anilkumar-3187

Thank you for confirming that you got the answer as documented here.

Regards
Navtej S


1 Vote 1 ·
Show more comments