Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Something is changing the RECOVERY MODE to SIMPLE to ALL databases... RE: Something is changing the RECOVERY MODE to SIMPLE to ALL databases...

  • May 27, 2013 at 10:49 am

    #1618812

    Lorenzo Mota (5/27/2013)

    So, besides the DTS, is there anything automatic or internal of SQL Server that could be doing this?

    No. SQL will never automatically change database settings. If recovery model is changing, you have some task that someone created which is doing that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass