Quickest way to find the recovery model of any database

This post was written by namwar on April 16, 2008
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’

Tags: , ,

Add a Comment

required, use real name
required, will not be published
optional, your blog address