0

I'm trying to incorporate the use of Azure SQL Managed Instance in my organization, being one the reason the data virtualization capability that Azure SQL doesn't have.

I was trying the pricing calculator and got confused about two items in its configuration

enter image description here

What is the difference between Backup Storage Layer and Disaster Recovery? Both of them are related to backup, but I'm little confused, specially when it comes to a propper production environment.

Thanks and regards

David Makogon
  • 69,407
  • 21
  • 141
  • 189
jona
  • 23
  • 4
  • Product support/pricing questions are off-topic here. I suggest starting with the docs (or posting to an Azure-specific support forum). Aside from that: this is not a programming question. – David Makogon Jul 22 '23 at 04:13

1 Answers1

0

Based on the Azure SQL Managed Instance pricing page, the Backup Storage Tier is the type of storage used for storing automated backups of your databases. You can choose between locally redundant storage (LRS), zone-redundant storage (ZRS), geo-redundant storage (GRS), or read-access geo-redundant storage (RA-GRS). The default option is GRS, which means your backups are replicated to a paired region for disaster recovery purposes. The cost of backup storage depends on the amount of data stored and the type of storage chosen. To help you choose the right backup storage type and reduce costs please read this support article.

The Disaster recovery option is the ability to restore a database from a geo-replicated backup to a different region in case of a regional outage or disaster. This option is only available if you use GRS or RA-GRS for your backup storage tier. The cost of disaster recovery is based on the compute and storage resources used for the restored database in the target region. Here (a Nov 2022 support article) you will find that licensing of geo-redundant Disaster Recovery for SQL Managed Instance (in preview) is free.

In summary, the backup storage tier determines where and how your backups are stored, while the disaster recovery option determines whether and how you can restore your backups to a different region. They are indeed related but they are not the same. In addition, here you will find how to monitor Azure SQL Manage Instance costs.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
  • Brilliant explanation my friend. ¿What could it be the reason of a intance without the disaster recovery applied being more expensive than one that has it? Playing around with the calculator, if you chose to have a disaster recovery on your instance, your overall price is lower ... ¿Why? Perphaps I'm missing something to decide whether to use disaster recovery .. – jona Jul 22 '23 at 04:28
  • Remember with Disaster Recover (because is in preview, you get a discount on licensing (is free). – Alberto Morillo Jul 22 '23 at 05:39