seniorT-SQL

What is SQL Server recovery model and how does it affect backups?

Updated May 17, 2026

Short answer

Recovery models control transaction logging and backup capabilities.

Deep explanation

SQL Server has Simple, Full, and Bulk-Logged recovery models. Simple truncates log automatically, limiting point-in-time recovery. Full retains all log records until backed up, enabling point-in-time recovery. Bulk-Logged reduces log usage for bulk operations but sacrifices fine-grained recovery for those operations.

Unlock with a Pro subscription to view this section.

View pricing

Real-world example

No real-world example available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Common mistakes

No common mistakes listed yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Follow-up questions

No follow-up questions available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

More T-SQL interview questions

View all →