List Recovery Model and Compatibility Level for MS SQL DB

May 9, 2017 Jordansphere MS SQL

Use this query to select the recovery model and compatibility level of a DB on a MS SQL 2005 server.


 

select
   name, recovery_model_desc, compatibility_level
from
   sys.databases

SQL_recovery_model

Powered by WordPress. Designed by elogi.