Regarding ZRS redundancy of Backup Storage for Azure Database for PostgreSQL (Flexible Server), is a replica created for ZRS? [2210170060000616]

Question

Hello Team,

Regarding back up costs for Azure Database for PostgreSQL (Flexible Server).
When setting the availability of the Backup to GRS, the Storage cost becomes double that of LRS.
In the pricing page of flexible server: https://azure.microsoft.com/en-us/pricing/details/mysql/flexible-server/, the reason given is:

----------------------

GRS requires twice the amount of storage capacity because it creates a replica. If you have configured the backup storage to be geo-redundant (GRS), the price will be 2x this price. Price per GB remains the same.

----------------------

What about for ZRS? Is a replica created when ZRS is used?

Thank you

Answer 1

Hi @Peter Thurwachter (MINDTREE LIMITED) ,

Thanks for posting question in Microsoft Q&A platform.

Regarding your ask about ZRS, yes, if the region supports multiple availability zones, the backup is stored on a zone-redundant storage account so that you can restore to another zone.

`Zone-redundant backup storage: This option is automatically chosen for regions that support availability zones. When the backups are stored in zone-redundant backup storage, multiple copies are not only stored within the availability zone in which your server is hosted, but also replicated to another availability zone in the same region.

This option provides backup data availability across availability zones and restricts replication of data to within a country/region to meet data residency requirements. This option provides at least 99.9999999999 percent (12 nines) durability of backup objects over a year.`

Flexible Server provides up to 100 percent of your provisioned server storage as backup storage at no additional cost. Any additional backup storage that you use is charged in gigabytes per month.

For example, if you have provisioned a server with 250 gibibytes (GiB) of storage, then you have 250 GiB of backup storage capacity at no additional charge. If the daily backup usage is 25 GiB, then you can have up to 10 days of free backup storage. Backup storage consumption that exceeds 250 GiB is charged as defined in the pricing model

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification