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, no log backups), Full (complete logging, point-in-time recovery), and Bulk-logged (minimal logging for bulk operations). Since all three listed options (Simple, Bulk Logged, Full) are valid recovery models, 'All of the above' is the correct answer.

Keep practicing — related questions