Disaster Recovery & Business Continuity

When your business relies on a bespoke web or Android system, downtime isn’t just “an IT issue” — it means lost revenue, missed jobs, and staff reverting to spreadsheets. I help SMEs put practical disaster recovery (DR) and backup plans in place so your .NET, SQL Server, hosting and integrations can be restored quickly and predictably.

The focus is on simple, robust procedures you can actually follow during an incident — not a 60-page document that nobody reads.

RTO / RPO

Agree realistic recovery targets so decisions are clear before anything breaks.

SQL Server backups

Full, differential and log backups with retention, encryption and verification.

Off-site copies

Backups that survive server loss, ransomware, or a hosting account issue.

Tested restores

Because a backup you’ve never restored is just a hope — not a plan.

What I cover

DR isn’t only about the database. A realistic plan covers your whole system: hosting, apps, data, integrations, DNS/email, and the people/process bits that make recovery possible under pressure.

Risk & dependency mapping

  • Identify single points of failure (server, database, storage, certificates, DNS, email)
  • List critical integrations (payment providers, SMS/email, APIs, identity providers)
  • Highlight high-impact scenarios: hosting outage, ransomware, accidental deletion, bad deploy
  • Decide what “must be back today” vs “can wait until tomorrow”

Recovery targets (RTO & RPO)

  • RTO: how quickly you need the system back (e.g. 2 hours, same day, 48 hours)
  • RPO: how much data you can afford to lose (e.g. 15 minutes, 1 hour, 24 hours)
  • Translate targets into concrete actions (backup frequency, log backups, replication, hosting choices)
  • Make trade-offs explicit: cost vs complexity vs recovery speed

SQL Server backup strategy (done properly)

Typical components

  • Full backups on a sensible schedule (often nightly)
  • Differential backups to reduce restore time where appropriate
  • Transaction log backups for tighter RPO (e.g. every 5–15 minutes)
  • Encryption for backup files and protected credentials/keys
  • Retention policy aligned to your operational and compliance needs
  • Verification (checksums / integrity checks) so failures are noticed early

Common pitfalls

  • Backups stored on the same server (won’t survive disk loss or ransomware)
  • “We do backups” but nobody can actually restore under time pressure
  • Missing log backups / wrong recovery model
  • Backups failing quietly due to space/permissions
  • No plan for app secrets, certificates, or environment configuration

Off-site backups & the “3-2-1” mindset

A practical rule of thumb is 3-2-1: three copies of your data, on two different media/storage types, with at least one copy off-site. The exact implementation depends on your hosting and budget, but the principle is the same: don’t let one incident wipe out everything.

Cloud/off-site options

  • Secondary storage account or bucket with restricted access
  • Immutable / write-once style storage where available (ransomware resilience)
  • Separate credentials from the main server (reduce blast radius)
  • Retention tiers: short-term fast restore + longer-term archive

Access control & safety

  • Least privilege for backup jobs (only what they need)
  • Separate admin accounts and MFA for backup storage
  • Alerting on backup failures and unusual delete activity
  • Documented key/credential recovery process

Recovery runbooks (step-by-step, under pressure)

The best DR plans are short, clear and executable. I produce runbooks that cover the most likely scenarios and include the “small” details people forget (DNS, certificates, app secrets, service restarts, and how to verify things).

Examples of runbooks

  • Restore SQL Server database to a new server
  • Recover from accidental deletion / bad data import
  • Rebuild a web server/app service from known-good configuration
  • Roll back a deployment safely
  • Recreate scheduled jobs, background workers, and integrations

Verification checklist

  • App boots and health checks pass
  • Users can log in and key workflows work
  • Recent data is present (RPO met)
  • Background tasks and emails/SMS are functioning
  • Monitoring and alerts are back in place

Android & mobile considerations

If you have an Android app, resilience isn’t only about the server. Mobile apps can keep the business moving during an outage if offline mode is designed sensibly — and they can cause pain if sync/retry behaviour is chaotic.

Offline-first (where appropriate)

  • Clear rules on what can be captured offline (forms, photos, signatures)
  • Queue-and-sync patterns that avoid duplicate submissions
  • Conflict handling (what happens if two people edit the same record)
  • Safe retry/backoff so outages don’t hammer your API

Communication during incidents

  • In-app status banners (known outage, degraded mode, maintenance windows)
  • Fallback workflows for critical operations
  • Clear support escalation paths for staff in the field

Outcomes for your business

The goal is to move from “we hope it will be fine” to “we know exactly what to do”.

Operational confidence

  • Confidence your core systems can be recovered if hosting or hardware fails
  • Reduced risk of permanent data loss
  • Clear responsibilities and emergency contacts
  • A realistic picture of downtime and cost

Better stakeholder conversations

  • Better answers for customers and suppliers when asked “what’s your DR posture?”
  • Improved conversations with insurers and auditors
  • Less dependence on a single “key person”

FAQ

How often should we test restores?

At least periodically — and always after major infrastructure changes. Many teams only discover issues when it’s too late. A lightweight restore test can be quick, and it dramatically increases confidence.

Is “high availability” the same as disaster recovery?

Not quite. High availability reduces downtime for certain failures, but it doesn’t replace backups or protect against accidental deletion, ransomware, or bad data. Most SMEs benefit from solid backups + a clear runbook first.

Need a disaster recovery review?

If you’re not sure how you’d restore your system if the server failed tomorrow, it’s worth a short conversation. I can review your current setup and highlight quick wins as well as longer-term improvements.

Ask about disaster recovery
Mention your hosting/database setup and any target downtime you’re aiming for.