Does SQL Server support exactly three recovery models named Simple, Full, and Bulk, or is the correct name “Bulk-logged” rather than “Bulk”?

Introduction / Context:
Recovery models define how SQL Server logs transactions and what restore strategies are possible. Precise terminology matters because documentation, scripting, and compliance requirements reference the official names.

Given Data / Assumptions:

• We are discussing database-scoped recovery models.
• SQL Server supports three models.
• We care about their official names.

Concept / Approach:
The three supported recovery models are: SIMPLE, FULL, and BULK_LOGGED. BULK_LOGGED is often abbreviated verbally, but “Bulk” by itself is not the official or accepted model name. BULK_LOGGED allows minimal logging for certain bulk operations while still permitting point-in-time recovery under constraints.

Step-by-Step Solution:
Check current model: SELECT recovery_model_desc FROM sys.databases WHERE name = DB_NAME();Alter model: ALTER DATABASE MyDB SET RECOVERY BULK_LOGGED;Note the keyword is BULK_LOGGED, not BULK.

Verification / Alternative check:
SSMS database properties show the three choices exactly as Simple, Full, and Bulk-logged.

Why Other Options Are Wrong:
“Correct — Simple, Full, and Bulk” misnames the third model. The claim that only two models exist is false. Recovery model is per-database, not per server; compatibility level does not define recovery model.

Common Pitfalls:
Assuming “Bulk” is valid syntax; attempting ALTER DATABASE ... SET RECOVERY BULK will fail.

Final Answer:
Incorrect — the correct name is Bulk-logged, not Bulk