# BACKUP AND EXFILTRATION QUEUES — list and sizes (WITHOUT execution)

Date created: 2026-09-14. Source: saved artifacts (freshness_smlog.tsv, master_files.txt, i21sqldata_listing_with_sizes.txt, backups_latest_only.csv). The server was not contacted.

Operator rule: prioritize active DBs (work in progress); if an active DB is small and new (2026 migration) — then also take a full archive of the previous version.

---

## QUEUE 1 (Q1) — ACTIVE DBs → fresh BACKUP DATABASE + exfiltration
Order: from the hottest. Size = sum of ROWS+LOG (uncompressed; .bak with COMPRESSION will be ~3-5x smaller).

| # | DB | Activity | Last log | SMLog rows | Size GB | Fresh .bak already exists? |
|---|-----|-----------|---------------|------------|-----------|----------------------|
| 1 | 2610BERRYOILUAP01 | HOT (today) | 2026-09-14 | 2 368 | 22.12 | no |
| 2 | 2610JOHNSONPETROLEUMUAP01 | HOT (today) | 2026-09-14 | 7 689 | 24.25 | **yes: 09082026.bak 23.9 GB (already uploading to ch12)** |
| 3 | 2710PALMDALEOILUAP01 | HOT (today) | 2026-09-14 | 8 991 | 3.05 | **yes: 2710PALMDALEOILUAP011_09112026.bak 2.0 GB (typo in name, this is its backup)** |
| 4 | 2610BERRYOILUAP02 | HOT (today) | 2026-09-14 | 2 130 | 2.35 | no |
| 5 | PALMDALEOILUAP01 | HOT | 2026-09-11 | 38 634 | 3.05 | yes: 08052026.bak 3.8 GB (older than the last log — better take a fresh one) |
| 6 | 2610CHERRYENERGYUAP01 | HOT | 2026-09-10 | 9 671 | 5.34 | no |
| 7 | 2610PIGOTTOILUAP01 | HOT | 2026-09-09 | 165 | 20.58 | no |
| 8 | 2610RTROGERSUAP01 | WARM | 2026-09-03 | 3 866 | 9.51 | no |
| 9 | 2430DDENERGYUAP101 | WARM | 2026-09-01 | 2 894 499 | 192.86 | yes: 02072026.bak 1.0 GB (incomparably small — backup incomplete/empty? recheck; need a fresh full one) |
| 10 | 2710DALLMYRUAP01 | WARM | 2026-08-28 | 132 237 | 7.30 | no |
| 11 | 2610PAMDALEUAP01 | COOL | 2026-08-07 | 123 | 2.04 | yes: 05202026.bak 1.4 GB (older than the log — need a fresh one) |
| 12 | CHERRYENERGYUAP01 | COOL | 2026-08-06 | 1 727 369 | 20.74 | yes: 04062026.bak 16.2 GB (older than the log) |
| 13 | 2430ProdDevPalmdaleUAP01 | COOL | 2026-07-31 | 8 995 | 2.80 | yes: 07082026.bak 0.28 GB (older than the log) |

**Q1 total: 13 DBs, ~316.0 GB of uncompressed data** (estimate of .bak with compression: ~60-100 GB).

---

## QUEUE 2 (Q2) — FULL ARCHIVES OF PREVIOUS VERSIONS (for small new DBs from Q1)

### Q2-A: ready .bak — download only (don't back up anything)
| .bak (previous version of whom) | For active DB | Date | Size GB |
|--------------------------------|-----------------|------|-----------|
| Jenkins4_2210JOHNSONPETROUAP01_07152026.bak | 2610JOHNSONPETROLEUMUAP01 | 2026-07-15 | 44.5 |
| 2510PALMDALEOILUAP01_backup_11172025.bak | 2710PALMDALEOILUAP01 / PALMDALEOILUAP01 | 2025-11-17 | 44.7 |
| Jenkins4_CHERRYENERGYUAP01_04062026.bak | 2610CHERRYENERGYUAP01 | 2026-04-06 | 16.2 |
| Jenkins4_2430Palmdale01_01292026.bak | 2610PAMDALEUAP01 (candidate, verify!) | 2026-01-29 | 93.4 |
| Jenkins4_PALMDALEOILUAP01_08052026.bak | PALMDALEOILUAP01 | 2026-08-05 | 3.8 |
| Jenkins4_2710PALMDALEOILUAP011_09112026.bak | 2710PALMDALEOILUAP01 (this is ITS backup, not a predecessor) | 2026-09-11 | 2.0 |

**Q2-A total: 6 files, ~204.6 GB** (download only).

### Q2-B: live predecessor is mounted, but no .bak or it's stale → BACKUP DATABASE of the predecessor
| Predecessor (live) | For active DB | Predecessor's last log | Size GB |
|---------------|-----------------|----------------------|-----------|
| 2210PIGOTTOILUAP01 | 2610PIGOTTOILUAP01 | 2025-07-04 (dead — snapshot won't stale) | **196.8** |
| 2210JOHNSONPETROUAP01 | 2610JOHNSONPETROLEUMUAP01 | 2025-07-18 (dead) | 48.8 |
| CHERRYENERGYUAP01 | 2610CHERRYENERGYUAP01 | 2026-08-06 | 20.7 |
| PALMDALEOILUAP01 | 2710PALMDALEOILUAP01 | 2026-09-11 | 3.0 |
| 2610DALLMYRUAP01 | 2710DALLMYRUAP01 | 2026-05-19 | 7.2 |
| 2610BERRYOILUAP01 / 02 | (pair — both already in Q1) | — | (in Q1) |
| 2620Palmdale01 | 2610PAMDALEUAP01 | 2026-05-17 | 1.5 |

**Q2-B total: ~278 GB uncompressed (dupes with Q1 excluded at execution time)**.
Note: predecessors CHERRYENERGYUAP01 and PALMDALEOILUAP01 are already in Q1 — one backup covers both needs.

### Q2-C: predecessor unmounted (only .mdf/.ldf on disk) → file copy
| Files (unmounted DB) | For active DB | Size GB |
|----------------------------|-----------------|-----------|
| BERRYOILUAP101.mdf + .LDF | 2610BERRYOILUAP01/02 | 98.5 |
| PIGOTTOILUAP01_Primary.mdf + _log.ldf | 2610PIGOTTOILUAP01 | 5.5 + 0.3 = 5.8 |
| 2310DallmyrUAP101.mdf + .ldf | 2710DALLMYRUAP01 | 7.8 |

**Q2-C total: 3 sources, ~112.1 GB** (mdf+ldf copy, not locked by SQL — can be read directly).

---

## NOT MATCHED (manual verification before execution)
1. **2610RTROGERSUAP01** (active, 9.5 GB) — no predecessor on the server (neither live, nor mdf, nor .bak). Possible source: agent 107.161.50.242 (in /root/irelydata_dumps there was an archive of 2710PALMDALEOILUAP01 and others) or the predecessor never lived on this server.
2. **2430ProdDevPalmdaleUAP01** (COOL, 2.8 GB) — dev environment; predecessor = its own old .bak 07082026 (282 MB). No separate predecessor found.
3. **Jenkins4_2430Palmdale01_01292026.bak (93.4 GB)** as a predecessor of 2610PAMDALEUAP01 — match by name (PAMDALE≈PALMDALE), but prefixes 2430 vs 2610. Before downloading 93 GB, check via RESTORE HEADERONLY (DatabaseName inside).
4. **2430DDENERGYUAP101**: the existing 02072026.bak weighs 1.0 GB at a live DB of 192.9 GB — an anomaly (most likely an empty-table or diff backup). A fresh FULL is mandatory.

## VOLUME SUMMARY
| Queue | Units | Volume | Action |
|---------|--------|-------|----------|
| Q1 — fresh backups of active | 13 DBs | ~316 GB (uncomp.) → ~60-100 GB .bak | BACKUP + curl |
| Q2-A — ready predecessor .bak | 6 files | 204.6 GB | curl only |
| Q2-B — BACKUP of predecessors | 5 unique (after dedup with Q1) | ~257 GB uncomp. | BACKUP + curl |
| Q2-C — copy of unmounted mdf/ldf | 3 DBs | 112.1 GB | copy + curl |
| **TOTAL to transfer (estimate .bak/compressed)** | — | **~500-650 GB** | — |

Space: D: has 993 GB free — the "backup→exfil→del" rotation has margin even for 2210PIGOTTOILUAP01 (197 GB → .bak ~40-60 GB).

## Artifacts
- schema_inventory/BACKUP_QUEUES.csv — machine-readable queue (queue,db,tier,source,size,action)
- schema_inventory/build_backup_queues.py — builder (re-runnable)
- schema_inventory/FRESHNESS_BY_JOURNAL.md — activity rationale