Data Backup and Restore SOP Template

I wrote this for a small business that wants backups it can rely on. It follows the 3-2-1 idea, three copies on two kinds of storage with one off site, and it makes the restore test a routine step instead of an afterthought.

Purpose

Make sure business data can be recovered after deletion, failure, ransomware or disaster, within the time and data loss the business can accept.

Scope

Covers servers, databases, cloud services and shared files that hold business data. Personal devices, one-off migrations and archiving for legal retention are covered by their own procedures.

Roles and responsibilities

RoleResponsibility
Backup administratorConfigures and monitors backups, handles failures and performs restores.
Data ownerDecides how important each data set is and how much loss is acceptable.
IT managerApproves the policy, reviews the monthly report and reports risks to management.
ReviewerChecks the restore tests and confirms the results are recorded.

Prerequisites

  • An inventory of systems and data sets, with an owner for each
  • A recovery point objective and recovery time objective agreed with each data owner
  • Backup software or the cloud provider's backup service, with admin accounts held by named people
  • Storage for local backups and a separate location or provider for the off-site copy
  • A place to store encryption keys that is not on the systems being backed up

Procedure

  1. List what must be backed up. With the data owners, list systems, databases, cloud accounts, configuration and shared files. Mark which data is critical, and note where each lives.
  2. Set recovery objectives. For each data set write the longest acceptable data loss (recovery point) and the longest acceptable downtime (recovery time). These decide how often you back up and how you restore.
  3. Choose the schedule and retention. Set the frequency from the recovery point, for example hourly or daily for critical data, and the retention, such as daily copies for a month and monthly copies for a year, as your needs and rules dictate.
  4. Follow the 3-2-1 rule. Keep three copies of important data: the live copy and two backups, on two different kinds of storage, with one copy off site and, where you can, one that cannot be changed or deleted for a set time.
  5. Encrypt and protect the backups. Encrypt backups in transit and at rest, store keys separately, use dedicated backup accounts with multi-factor authentication and do not let ordinary user accounts delete backups.
  6. Configure the jobs. Set up the jobs, include databases using their own export or snapshot method so files are consistent, and write down the job names, schedules and destinations in the inventory.
  7. Monitor every job. Send success and failure results to a mailbox or channel that someone reads. A backup that fails silently is the same as no backup.
  8. Handle failures. On a failure, the administrator reruns the job the same day, finds the cause, and tells the data owner if the recovery point objective has been missed.
  9. Test a restore every month. Restore a chosen file, database or server into a test location, check that the data opens and is complete, time the restore and compare it with the recovery time objective. Rotate which data you test so all of it is covered in a year.
  10. Record the test. Write the date, what was restored, who did it, how long it took and the outcome in the restore log. The reviewer signs it. Fix and re-test any failure.
  11. Review the policy. At least once a year and after any major change of systems, review the inventory, objectives, schedule and retention, remove backups of retired systems according to your policy and update this document.

Revision history

VersionDateAuthorChange
1.0[Date][Name]First version

Assign this SOP to your team and track who has read it

The Word export uses the docx library (MIT licence).

How it works, and what stays on your device

Download the template as a Word file or as Markdown. Both are built in your browser from the text on this page, so nothing is uploaded and nothing is sent to a server.

Copy to Google Docs puts the template on your clipboard as formatted text, then opens a new Google Doc in another tab. Paste it there with Ctrl+V, or Cmd+V on a Mac. Google only sees what you paste.

Fill in the square brackets, change anything that does not match how your team works, and add a row to the revision table each time you change it.

Frequently asked questions

What does 3-2-1 mean?

Three copies of your data, on two different kinds of storage, with one copy off site. It protects against a single failure, a single site disaster and many cases of ransomware.

Is syncing to a cloud drive a backup?

Usually not. Sync copies deletions and corruption to every device. A backup keeps earlier versions you can go back to.

How often should I test restores?

Monthly is a good routine for critical data. The point is to find problems when you can fix them, not during an emergency.

How long should I keep backups?

Long enough to recover from mistakes you notice late, and as long as any law or contract requires. Write the retention for each data set into step 3.