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 • 792 views
MS-SQL Server developer interview questions
Advanced level • 311 views
MySQL management interview questions
Beginner level • 220 views
How would you model a many-to-many relationship between students and courses?
Medium level • 53 views
What is normalization, and when might denormalization be justified?
Easy level • 50 views