January 19, 2009 at 9:28 am
Hello,
I have 1 database on my server that the recovery model is automatically changing from full to simple making my transaction log backup routines fail. This is the only way currently I know that this has adjusted and obviously I don't want it to change from full. I am the only one who has access to the server with permissions to change this. Is there anything that I can use to monitor to see what process is changing this or some other way to investigate this issue to get it resolved. Any help you could provide would be greatly appreciated.
January 19, 2009 at 9:38 am
Jason Manthei (1/19/2009)
Hello,I have 1 database on my server that the recovery model is automatically changing from full to simple making my transaction log backup routines fail.
SQL will not automatically change a recovery model. Some code, somewhere is running to do the change. Check the jobs that are running around the time that the log backups start failing. I've seen index rebuild jobs that start by switching the DB to simple.
Is it happening regularly (at a certain time every day/week)? If so, run a profiler trace and see if there are any ALTER DATABASE commands, what login is running them and from what app and machine
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply