← Engineering notebook
Support & infrastructure

Database recovery in manufacturing systems

When data is at risk, the first priority is preserving it - not troubleshooting.

Several support incidents taught me the same hard lesson: when data is at risk, the first priority is preserving the data, not troubleshooting.

Recovery process

  1. Stop making changes.
  2. Create backups before touching anything.
  3. Preserve evidence (logs, exact state).
  4. Verify storage health.
  5. Verify database integrity.
  6. Recover first, optimize later.

Why the order is strict

Every well-intentioned "quick fix" applied before a backup is a chance to turn a recoverable incident into permanent data loss. Discipline beats cleverness here.