Back Up and Running in 30 Minutes: A Real Recovery Story

A third-party update corrupted a customer’s production database. Thirty minutes later, they were working again. Here’s why.

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.

Recovering from a corrupted database with and without continuity

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.

Affirm IT provides IT support in Derbyshire for manufacturers and growing businesses, from our office in Heanor, Amber Valley.

How does your IT measure up?

Take our free 2-minute IT scorecard and get a clear, plain-English breakdown of where your business stands.

Other blogs you may like

What does an hour of downtime cost you?

What Does an Hour of Downtime Cost a Manufacturer?

Eighty people standing idle costs £1,200 an hour in wages alone. The visible and hidden costs of downtime, and how to work
Picture of Phil Davenport

Phil Davenport

Your customer wants Cyber Essentials

Your Customer Wants Cyber Essentials. What Now?

Your biggest customer wants proof of Cyber Essentials by next month. Why they’re asking, where manufacturers get caught out, and a simple
Picture of Phil Davenport

Phil Davenport

Is your ERP a single point of failure?

Is Your ERP System a Single Point of Failure?

“If the system goes down, we stop.” The five single points of failure around most manufacturers’ ERP systems, and how to reduce
Picture of Phil Davenport

Phil Davenport