T-SQL – Checking Database Recovery Model
If you want to check current Database Recovery Model, then below script would be a great help.
SELECT [name],state_desc,recovery_model_desc FROM sys.databases
There are 3 types of recovery model in SQL Server:
- Full – Requires log backups.
- Simple – No log backups.
- Bulk Logged – Requires log backups ( minimal logging)
To read more about recovery models read the below MSDN Article