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

› Category: SQL › What is the recovery model? List the types of recovery models available in SQL Server?
0 Vote Up Vote Down
Editor">Editor Staff asked 2 years ago

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

Question Tags:
1 Answers
0 Vote Up Vote Down
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