Why it matters
Nobody sees these backups once the database is gone, so they can be billed for years. Large production databases leave large backups behind.How nOps finds it
nOps reads your RDS billing for the last 90 days. A backup is flagged when its backup storage costs at least $5 a month, was billed on at least 28 of the last 30 days and is still billed, and either the database it belongs to has had no other RDS charges for at least 30 days, or it is a manual snapshot billed on at least 85 of the last 90 days. Backups managed by AWS Backup and automated snapshots of running databases are left out, because their retention is set elsewhere. The saving is the whole backup storage charge for the last 30 days.Before you start
Confirm the backup is not needed for compliance, legal hold or a planned restore. Permission to delete RDS snapshots and automated backups.How to implement
- Confirm the database is really gone and that nobody needs to restore it.
- If the data must be kept, export the snapshot to S3 first (RDS console → Snapshots → Actions → Export to Amazon S3).
- For a manual snapshot, delete it (
aws rds delete-db-snapshot --db-snapshot-identifier SNAPSHOT_ID, oraws rds delete-db-cluster-snapshotfor Aurora). - For retained backups of a deleted database, list them with
aws rds describe-db-instance-automated-backups(ordescribe-db-cluster-automated-backupsfor Aurora) and delete them withaws rds delete-db-instance-automated-backup --dbi-resource-id DBI_RESOURCE_ID(ordelete-db-cluster-automated-backup). - Check the next days’ billing to confirm the backup storage charge has stopped.
Risks and considerations
- Deleting a backup is permanent and cannot be undone.
- A snapshot exported to S3 can be queried but cannot be restored as a database directly. Keep the snapshot if you may need to restore.
- Copies of the snapshot in other regions or accounts are billed separately and are not deleted with it.
FAQs
Why are AWS Backup recovery points not included?
Why are AWS Backup recovery points not included?
Their lifetime is set by your backup plan. Change the plan’s retention instead of deleting points by hand.
What counts as a deleted database?
What counts as a deleted database?
One whose backups are still billed but that has had no other RDS charges, such as instance hours or storage, for at least 30 days.