Answer
Full: Entire database.
Differential: Changes since last full.
Log: Captures all log records since last log backup.
Quick Answer
Full backup: entire database, self-contained restore point. Differential backup: only pages changed since the last full backup — faster than full, smaller file. Log backup: transaction log since last log backup — enables point-in-time recovery. Together they form a restore chain: full + diff + logs.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ