• select * from sys.databases where name = 'dbname'

    state_desc = RECOVERING