What is the recovery model? List the types of recovery model available in SQL Server?
Ask by MindStick Software Pvt Ltd
Updated 19 Sep 2020
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: