Azure SQL PiTR - Option to disable or set to 1 day retention
We currently have an SQL managed database, which we use for development purposes.
We are developing how our data ingest will work, currently we drop the tables every day, and re-load all the data. As of the 31-AUG we started getting charged for PiTR which we didn't know about, until PiTR started costing us upwards of $120 per day.
What I found out is after the initial backup (free) any changes were replicated to 6 regions (GRS storage) and set to 35 days retention period. These are backups we don't want or need, as data is ingested from the Datalake. Currently there is no option to turn this feature off, and the min number of days retention is 7 days.
Cloud being pay for what you use, and use what you want. There is no way to avoid these charges, unless we pay for provisioned SQL via the DTU model where PiTR is not charged. But we are using the serverless feature of vCores.
Please provide an option to turn off PiTR or set it to 1 day.
Nigel Rablin commented
This is important to have the option. For our non-production workloads this is costing us when we really do not need to recover at point in time. For production workloads we also need the option to decide whether each database is important enough to keep a PIT.