MindStick Software Pvt. Ltd. is a Microsoft Gold Partner in software application development. Our expertise is in software product design, custom programming, database design, web design and programming and cutting edge mobile applications development.
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
Liked By
Write Answer
What is the recovery model? List the types of recovery model available in SQL Server?
Join MindStick Community
You have need login or register for voting of answers or question.
MindStick Software Pvt Ltd
19-Sep-2019The 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: