How would you verify that a database backup is usable?
Interactive Practice Mode
Formulate your thoughts or take notes before revealing the model solution.
Saved automatically
Model Answer & Deep-Dive Explanation
Restore it into an isolated environment with compatible software and required encryption keys, then check structural integrity and important application-level invariants. Verify expected tables, representative records, timestamps, and recovery procedures. Measure restoration time against the recovery-time objective and confirm the recoverable point meets the recovery-point objective. Include logs needed for point-in-time recovery when applicable. A completed backup job and a file checksum only show that a file was produced consistently; they do not prove that the organization can restore a functioning application.
Related Questions in Database
DBA Interview Questions
Intermediate level • 744 views
MS-SQL Server developer interview questions
Advanced level • 264 views
MySQL management interview questions
Beginner level • 169 views
Why can a replica return stale data immediately after a successful write?
Medium level • 5 views
What is normalization, and when might denormalization be justified?
Easy level • 4 views