---
title: "How do I back up a website and its database properly?"  
description: "How do I back up a website and its database properly?"  
author: "Mikko Lehtonen"  
published: 2026-11-19  
updated: 2026-11-19  
canonical: https://www.mindstick.com/forum/163084/how-do-i-back-up-a-website-and-its-database-properly  
category: "Cloud and Security"  
tags: ["backup", "Disaster Recovery", "sql server", "website maintenance", "data protection"]  
reading_time: 1 minute  

---

# How do I back up a website and its database properly?

Our small business site is on one server. We have never restored a backup. What is a safe setup?

## Replies

### Reply by Garima Negi

Backups protect you from deletion, hardware failure, ransomware and human error.

What to back up:

- **The database**: scheduled full backups, plus differential or transaction-log backups if you cannot lose much data. In SQL Server, use native backups with checksum.
- **The website files**: uploads, configuration and the application itself (or the code repository plus the deploy process).
- **Configuration and secrets** (stored securely).

Rules that matter:

- **3-2-1 rule**: three copies, on two different kinds of storage, one of them off-site (another region or cloud storage).
- **Keep backups off the main server**, and keep some copies isolated or immutable so ransomware cannot encrypt them.
- **Encrypt** them and control who can access them.
- **Automate** and monitor, so you are alerted when a backup fails.
- **Test restores** regularly, on a separate machine. Many people find out their backup is broken only when they need it.

Decide how much data loss (RPO) and downtime (RTO) your business can accept, and set the schedule accordingly.


---

Original Source: https://www.mindstick.com/forum/163084/how-do-i-back-up-a-website-and-its-database-properly

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.
