sys.database_recovery_status

Description

Contains one row per database. If the database is not opened, the SQL Server Database Engine To see the row for a database other than , one of the following must apply: Have ALTER ANY DATABASE or VIEW ANY DATABASE server-level permissions. Have CREATE DATABASE permission in the ID of the database, unique within an instance of SQL Server. Used to relate all the database files of a database together.