Multiple choice technology web technology

What are the different recovery models in SQL Server 2005?

  1. Simple

  2. Bulk Logged

  3. Full

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL Server 2005 supports three recovery models: Simple (minimal logging, auto-log truncation), Full (complete transaction logging, point-in-time recovery), and Bulk Logged (minimal logging for bulk operations). Since all three listed options are valid recovery models, 'All of the above' is correct.

Keep practicing — related questions