The update was meant to be routine.
A third-party software supplier pushed an update to one of our customers’ systems. Nothing unusual about that. It happens every week in businesses up and down the country.
Except this time, the update corrupted the production database.
The system the business runs on stopped working.
What Usually Happens Next
In a lot of businesses, this is where the panic starts.
- Somebody rings the software supplier and joins a queue
- Somebody else asks when the last backup was taken
- Production stops, and staff stand around waiting
- Everyone hopes the backup actually works
Even when the backup is good, restoring a large database can take hours. Sometimes the best backup available is from last night, which means a whole morning’s work has gone.

What Actually Happened
Because this customer had continuity in place, not just backup, we had a replica of the database up and running in 30 minutes.
The business lost 15 minutes of data.
Not a day. Not a morning. Fifteen minutes.
Backup and Continuity Are Not the Same Thing
A backup is a copy of your data. It means you can get it back eventually.
Continuity is how quickly the business keeps working while the problem is fixed.
Think of it like a spare tyre. A backup is knowing you can order a new tyre. Continuity is having the spare in the boot, so you can carry on with your journey today.
We explain the difference in more detail in Why Backups Don’t Keep Your Business Running.
The Two Questions That Matter
When something goes wrong, there are only two numbers you really care about:
- How much data can you afford to lose? Fifteen minutes? A day? A week?
- How long can you afford to be down? Half an hour? A morning? Two days?
Most businesses have never been asked these questions. And if nobody has asked, nobody has designed the IT to meet the answer.
It Wasn’t Anybody’s Fault
The software supplier didn’t set out to break anything. Updates go wrong sometimes. Hardware fails. People make mistakes.
You can’t stop every problem. What you can control is how much it hurts when one happens.
How We Check Backups Every Day
At Affirm IT, our customers’ backups aren’t just checked for green ticks. Every day, they’re restored and started, and we take a screenshot to prove the system boots. That way we know they work before anyone needs them.
Frequently Asked Questions
What is a database replica?
A replica is a second copy of a database that is kept up to date with the live one. If the live copy fails, the replica can take over far faster than restoring from a backup.
Do small businesses need continuity, or just backup?
It depends on how long you can manage without your key systems. If an hour of downtime stops production or leaves customers waiting, continuity is worth considering.
Need Help?
At Affirm IT, we start with simple questions:
- How much data could your business afford to lose?
- How long could you keep working if your main system stopped?
- When did someone last prove your backup works?
From there, we put the right level of protection in place for your business.
Not sure how your backups would hold up? Take our free 2-minute IT scorecard. Four questions, an instant result, and no email needed unless you want the breakdown.
Or get in touch with us. At Affirm IT, we provide IT support for manufacturers and managed IT support in Derbyshire and across the East Midlands.
