Post reply

How recovery mode of db gets changed

  • January 5, 2006 at 9:47 am

    #166398

    I have a database that has always been set to Full recovery mode and needs to stay that way.  Somehow in the last couple of days it has been being switched to Simple by someone or some procedure.  Is there a way to monitor the db with profiler that will let me know who or what is changing the recovery mode? 

  • January 5, 2006 at 10:00 am

    #612944

    Which database? Is it a system or user database?

    -SQLBill

  • January 5, 2006 at 10:18 am

    #612953

    User database.

  • January 5, 2006 at 11:39 am

    #612983

    Problem figured out.  Another user was running a version of Spotlight on SQL Server and had it pointing at the database in question instead of the QuestSoftware db.  Everytime he would start the Spotlight it would change the recovery mode of the db.  Pointed it to the correct db and problem is gone. 

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

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