DEV Community

Cover image for What Evidence Makes You Trust a Backup?
Umer Amin Durrani
Umer Amin Durrani

Posted on AI-assisted

What Evidence Makes You Trust a Backup?

You know the friend who says, “I'm five minutes away,” while still looking for their keys?

Sometimes a backup dashboard has that same energy.

“Completed successfully” sounds like the whole journey. Depending on the job, it may only describe one stage.

That doesn't make the dashboard useless. It means we should ask what its green tick actually measures.

Four different kinds of confidence

Here is a discussion framework, not an industry certification scheme:

Evidence What it helps establish What remains open
A recent file exists An artefact is present Is it complete, trusted and accessible when needed?
The backup operation succeeded The operation met its configured success criteria Can we restore it into the required environment?
A restore exercise passed That tested restoration worked under those conditions Can the application and its dependencies operate?
A recovery drill met its targets The tested service recovery met defined criteria Will changed infrastructure or a different incident break the assumptions?

The distinction matters because a backup tool, a database administrator and a customer may all mean different things by “working.”

The customer probably isn't interested in a screenshot of the cron job. Fair enough, honestly.

My favourite question for a recovery meeting

Not “Do we have backups?”

Try:

“What is the most recent recovery evidence, and what did that exercise leave untested?”

That question makes room for an honest answer. Maybe the data restored correctly, but nobody tested the application role. Maybe the files are solid, but retrieval depends on one person's account.

Those are useful findings. They are not reasons to roast whoever ran the drill.

A practice session that reveals a missing key is doing its job. Finding it during the outage is the inconvenient sequel.

A small action worth trying

At the next review, choose one important user journey. Write down how you would prove it works after restoration, which dependencies it requires and who can run that check.

No dramatic transformation programme needed. Just make one assumption visible.

For PostgreSQL specifically, the official backup and restore chapter is a useful starting point for understanding the different approaches.

Which recovery assumption has surprised you most: permissions, missing files, unavailable credentials, external integrations—or something completely different? Share the lesson without exposing customer data or internal credentials.

Draft prepared with AI support. The examples are discussion scenarios, not claimed personal incidents.

#Discuss #DevOps #Database #Productivity

Top comments (0)