---
title: "What is the recovery model? List the types of recovery model available in SQL Server?"  
description: "What is the recovery model? List the types of recovery model available in SQL Server?"  
author: "MindStick Software Pvt Ltd"  
published: 2019-09-19  
updated: 2020-09-19  
canonical: https://www.mindstick.com/interview/33629/what-is-the-recovery-model-list-the-types-of-recovery-model-available-in-sql-server  
category: "mssql server"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# What is the recovery model? List the types of recovery model available in SQL Server?

The **Recovery model** basically tells SQL Server what data should be kept in the transaction log file and for how long. The database can have only one recovery model.

This also tells SQL server that which backup is possible in a particular recovery model selected. There are three types of recovery model:

- Full
- Simple
- Bulk-Logged

## Answers

### Answer by MindStick Software Pvt Ltd

The **Recovery model** basically tells SQL Server what data should be kept in the transaction log file and for how long. The database can have only one recovery model.

This also tells SQL server that which backup is possible in a particular recovery model selected. There are three types of recovery model:

- Full
- Simple
- Bulk-Logged


---

Original Source: https://www.mindstick.com/interview/33629/what-is-the-recovery-model-list-the-types-of-recovery-model-available-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.