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 • 740 views
MS-SQL Server developer interview questions
Advanced level • 260 views
MySQL management interview questions
Beginner level • 165 views
How do a primary key, foreign key, and unique constraint serve different purposes?
Easy level • 1 views
What is normalization, and when might denormalization be justified?
Easy level • 1 views