Multiple choice technology databases

Which recovery model doesn't allow Log backups?

  1. Full

  2. Simple

  3. Bulk-Logged

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Simple recovery model does not support log backups - it automatically truncates the transaction log and minimally logs most operations. Full and Bulk-Logged recovery models both support log backups to enable point-in-time recovery.

Keep practicing — related questions