I'm running a BC 6-vcore Gen 5 single database with 1.5 TB of storage space. My PITR configuration is set to 7 days. I have been operating the server for 4 months. Beginning Sep 25, I began getting charged for "SQL Database Single/Elastic Pool PITR Backup Storage - RA-GRS Data Stored". I thought 7-day PITR was free according to the Microsoft documentation. I am trying to figure out how to stop these charges but have not found a solution.
Any thoughts? Am I missing something in the fine print?
From the docs at https://azure.microsoft.com/en-au/pricing/details/sql-database/single/
The backup cost depends on the size of the database, the rate of change and the configured retention period. The storage amount up to 100 percent of database size is provided at no extra charge. Additional backup storage consumption will be charged in GB/month
Actual backup storage required is difficult to estimate, but if you have a lot of change going on, the TL backups wll be bigger and that's more storage.
Throwing around some rought numbers;
If you have 1Gb of changes to your DB per day, it needs to store 7 days of changes (7 x 1Gb) + various other backups (probably at least one full backup plus a differential.
Because your DB is currently 1.5G, you get the first 1.5G free so you have to pay the balance of 5.5G
I'm not completely across the modelling and calculations and I'm not sure how they roll that up to a month, but that's what I get from the doco.
There was also a note saying it starts 1st November but I can't find that now.
Based on this official pricing calculator you have to pay $150 per month for backup storage (PITR) of 1.5 TB;
