# Backup & Disaster Recovery Plan

Protecting guest data, financial records, and operational availability through automated backups and tested restoration procedures.

---

## 1. Backup Strategy & Cadence

| Asset | Frequency | Storage Location | Retention Period |
| :--- | :--- | :--- | :--- |
| **MySQL Database Dump** | Daily (02:00 EAT) + Real-time WAL | Off-site Encrypted S3 / SFTP | 90 Days |
| **Uploaded Media (`storage/app/public`)** | Weekly Incremental | S3 Object Storage | 180 Days |
| **Configuration (`.env`, Settings)** | On Modification | Encrypted Vault | Indefinite |

---

## 2. Disaster Recovery & Restoration SOP

### 2.1 Database Restoration
```bash
# 1. Decompress the latest encrypted database backup
gunzip -c /backups/db/calian_hotel_2026_08_26.sql.gz > /tmp/restore.sql

# 2. Import into MySQL
mysql -u calian_user -p calian_production < /tmp/restore.sql

# 3. Clear application caches
php artisan cache:clear && php artisan config:clear
```