PAAS Database Backup storage maintenance and its pricing.

In this blog post we will see azure backup storage maintenance and its price for PAAS Databases. Basically we can maintain and store our database backups in azure using below options/methods:

1) PITR Backups (Point In Time Recovery)

2) LTR Backups (Long Term Recovery)

PITR Backups

• The Point In Time Recovery backups are configurable and can be set from 1, 7, 14, 21, 28, 35 days.

• Azure has to maintain Full, Differential and Transaction Log backup for supporting the PITR option that you have set.

• Any recovery in azure database starts with restoring the Full backup so for any day of the week even if the PITR is set for 1 day Azure has to keep the last Full backup.

• All the backups are always compressed, irrespective of whether you have enabled TDE or not.

• PITR Backups Costing :

  1. Azure doesn’t charge for taking backups and maintaining them but only the storage involved in keeping them is billed.

  2. For the DTU, model which is an exception, there is not additional cost of keeping the PITR backups as it is part of the database pricing.

  3. For the vCore model, the storage amount equal to 100 percent of the maximum data storage size for the database is provided at no extra cost anything more it is billed as:

Total billable backup storage size = (size of full backups + size of differential backups + size of log backups) – maximum data storage

LTR Backups

• Long Term DB Backups are stored separately than the PITR backups.

• Azure copies the relevant Full backups from the PITR backups and copies it to a different location. You cannot see the backups stored in some storage account like you maintain for PITR backups

• LTR doesn’t need to keep everything (Full, Differential and Transaction Log backups ) but just the Full backups.

• If you change the LTR from some previous configuration, the backups maintained for the old settings are not deleted but maintained till its life cycle. The new setting is only applicable to the new backups.

• LTR Backups Costing :

  1. These backups are always billed as per Azure pricing model.

  2. Please do check the Azure Pricing Calculator (<-- Click it) to calculate the pricing involved in maintaining the LTR backups.

That's all in this post. If you liked this blog and interested in knowing more about Azure, Please Like, Follow, Share & Subscribeto www.ImJhaChandan.com.