Is SQL database primium P1 storage service having default geo replication for DR

Question

Thank you very much in advance!!

We are using Azure SQL database PaaS. do azure providing default geo replication to achieve DR with premium storage or we need to configure active geo replication or auto failover group separately for respective database(s).

Answer 1

@Koustubh Nakate Welcome to Microsoft Q&A Forums and thank you for your interest in Azure SQL Database.

I believe you are referring to the High Availability (HA) replicas that are automatically provisioned with Premium and Business Critical service tiers.
This feature is called Read scale-out and is enabled by default with Premium and Business Critical service tiers.
The provisioned HA replicas are Zone Redundant and you can use them for balancing load across on your database by routing read only queries to them.

This is not to be confused with Active-GeoReplication which primarily serves as your Disaster recovery option in case an entire Azure region of your primary database goes down. You can use read-scale out along with geo replicated databases

In short, if you are OK with a zone redundant database, you should be good with using Read Scale-Out.
If you need DR across Azure Regions, you should provision a geo replicated database with auto failover groups.

We would be happy to answer any more questions you may have.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.