Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning See When the recovery model was switced on a database. RE: See When the recovery model was switced on a database.

  • 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