Posted Under: How-To, Object Search, Query, TSQL, Tips
Knowledge of recovery model of a database is one of the key information elements for any database administrator. If you want to quickly find the recovery model of a given database then you can use sys.databases system table where recovery_model_desc column value will tell you the recovery model of the respective database.
Following is an example to find the recovery model of AdventureWorks database
Select recovery_model_desc from sys.databases Where name=‘AdventureWorks’