April 15, 2009 at 7:23 am
does anyone have idea why is the recovery mode for one of dbs keeps changing itselft from full to simple during backup and then goes back to full after backup? thanks,
April 15, 2009 at 7:26 am
Probably because somewhere in the backup job there's code that switches the recovery model to simple and back to full. SQL won't just change the recovery model by itself. If I had to guess, I'd say it's because someone in the past didn't know how to manage transaction logs and found that this kinda did the trick, without realising what it actually does.
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
April 15, 2009 at 7:53 am
Gila thanks for replying...bakcup is done through maintenance plan..i just saw the eventvwr...i do see couple of times it does change the recovery to simple then back to full...im guessing there might be some other user-job which does that?..any idea
April 15, 2009 at 8:09 am
Then check other jobs that run at the same time. I don't know if it's possible to have custom scripts in a maint plan, if so check them. SQL won't change recovery models without being told to do so.
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
April 15, 2009 at 8:10 am
it is just regular maintenance plan..yeah i will check other jobs..i would also try looking at the default trace..do u think that will give some information?
April 15, 2009 at 11:12 am
i figured it out fromt he default trace..they had a job which was changing the recovery mode and then shrinking..i got that task removed..thanks..
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply