Skip to main content
When an RDS instance or Aurora cluster is deleted, its retained automated backups and manual snapshots stay, and you keep paying for their storage. nOps finds backups of databases that no longer run, and manual snapshots that have been kept for at least 90 days, and shows their full backup storage cost as the saving.

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

  1. Confirm the database is really gone and that nobody needs to restore it.
  2. If the data must be kept, export the snapshot to S3 first (RDS console → Snapshots → Actions → Export to Amazon S3).
  3. For a manual snapshot, delete it (aws rds delete-db-snapshot --db-snapshot-identifier SNAPSHOT_ID, or aws rds delete-db-cluster-snapshot for Aurora).
  4. For retained backups of a deleted database, list them with aws rds describe-db-instance-automated-backups (or describe-db-cluster-automated-backups for Aurora) and delete them with aws rds delete-db-instance-automated-backup --dbi-resource-id DBI_RESOURCE_ID (or delete-db-cluster-automated-backup).
  5. 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

Their lifetime is set by your backup plan. Change the plan’s retention instead of deleting points by hand.
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.