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

Category: SQLWhat is the recovery model? List the types of recovery models available in SQL Server?
Editor">Editor Staff asked 2 years ago

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

1 Answers
Editor">Editor Staff answered 2 years ago

The recovery model tells SQL Server what data should be kept in the transaction log file and for how long. A database can have only one recovery model. It also tells SQL server which backup is possible in a particular selected recovery model.
There are three types of recovery models:

  • Full
  • Simple
  • Bulk-Logged