Multiple choice technology databases

What are the 3 recovery models in SQL Server?

  1. Simple

  2. Full

  3. T-log

  4. Bulk-Logged
Reveal answer Fill a bubble to check yourself
A,B,D Correct answer
Explanation

SQL Server has exactly three recovery models: Simple (no log backups, minimal logging), Full (complete transaction logging, requires log backups), and Bulk-Logged (minimal logging for bulk operations, still point-in-time recovery). T-log is not a recovery model - it's shorthand for transaction log, which is a file, not a recovery model.

Keep practicing — related questions