Post reply

See When the recovery model was switced on a database.

  • January 24, 2014 at 7:07 am

    #396158

    Hi,

    Is there a way to See When the recovery model was switched on a database?

    Regards Urban

  • January 24, 2014 at 8:27 am

    #1683150

    Hi,

    There should be a message in the SQL Server error log, e.g. SETTING DATABASE OPTION RECOVERY TO SIMPLE FOR DATABASE XXXXX

    Also, i just changed the recovery model on one of my databases, and got an EventClass 164, ObjectType 16964 logged in the default trace, which might be worth looking up

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply