GilaMonster (5/27/2013)
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.
Like Gail said, this is something that somebody has created/written/implemented that is changing your recovery models.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events