T-SQL – Checking Database Recovery Model

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

Please Note:
There are 3 types of recovery model in SQL Server:

1. Full – Requires log backups.
   
2. Simple – No log backups.
   
3. Bulk Logged – Requires log backups ( minimal logging)
   

To read more about recovery models read the below MSDN Article

http://msdn.microsoft.com/en-us/library/ms189275.aspx