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

Last updated:9/19/2020 8:14:01 PM

1 Answers

MindStick Software Pvt Ltd
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