How to check the Database Recovery Model
- Details
- Created on Thursday, 15 April 2010 20:17
- Last Updated on Wednesday, 05 February 2014 07:25
- Written by Daniel Paessens
- Hits: 1905
A recovery model is used to determine what method is used to backup a database. They control transaction log maintenance, disk space capacity and can affect server performance. SQL Server has three types of recovery models Simple, Bulk-Logged and Full.