Answer
Simple: Auto-truncates log; no PIT recovery.
Full: Requires log backups; supports PIT recovery.
Bulk-Logged: Minimally logs operations.
Quick Answer
Simple: log is truncated at each checkpoint — no point-in-time recovery, just restore to last full or diff backup. Full: log is kept until backed up — allows point-in-time restore, required for AlwaysOn. Bulk-Logged: like Full but bulk operations are minimally logged — faster loads but can't do point-in-time around them.
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