How to check the Database Recovery Model

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.



Additional information