Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Find The Database Recovery Model

    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'

Viewing post 1 (of 1 total)