• You can also determine the recovery model using the function DATABASEPROPERTYEX

    It returns a SQL_VARIANT, so you need to convert it into character data

    CONVERT(NVARCHAR,DATABASEPROPERTYEX(' ','Recovery'))

    It will return 'FULL', 'SIMPLE' or 'BULK_LOGGED'