Azure SQL Database Backup

Question

hello,

Is we pay for every backup of SQL database? How we can know how much storage usage for every database?

Answer 1

On Azure SQL there could be additional charges for storage consumed by automated backups.

For Azure SQL DTU-model there is not additional costs for storage consumed by automated backups.

However, for Azure SQL vCore-model single databases, a backup storage amount equal to 100 percent of the maximum data storage size for the database is provided at no extra charge. The following equation is used to calculate the total billable backup storage usage:

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

To monitor the storage used by backups and their associated costs please visit Cost Management + Billing in Azure Portal and follow the steps provided here.

Answer 2

Hi @Handian Sudianto

The backup cost depends on the size of the database, the rate of change and the configured retention period. The backup storage amount equal to the maximum data size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month. Learn more about automated backups, and how to monitor and manage backup costs.

What purchase model your database is in?

You can select the pricing model and get the pricing information.

https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/

As per document -

For long term retention-

To answer your 2nd question,- How we can know how much storage usage for every database-

You can get that from the portal overview page of the database. like below-

Or from the Metric-

I hope this helps!

Let us know if you have any further questions or need additional information.

Thank you.