Answer
Restore order: Full ? Differential ? Logs. Use NORECOVERY until final restore, then RECOVERY.
Quick Answer
Restore sequence: 1) Restore the full backup (NORECOVERY), 2) Apply each differential/log backup in order (NORECOVERY), 3) Apply final log backup with RECOVERY to bring the database online. NORECOVERY keeps the database in restoring state so you can apply more backups; RECOVERY completes the restore.
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