• SELECT name

    FROM master.sys.databases

    WHERE recovery_model_desc != 'SIMPLE'

    Results:

    model

    ReportServer

    DATA2007

    model

    ISMDATA

    Users are changing and or adding an average of 100 records. Shall I still backup the log every hour?