Post reply

MSDB is reset to Simple recovery model, how can i avoid this?

  • February 22, 2007 at 12:45 am

    #172146

    I have schedueled a backup routine on our server that makes a full backup at midnight, and 2 transaction logs at lunchtime and afternoon. All the databases are set to FULL recovery model, but today I got a mail from my job, stating a failure. So I checked what went wrong, and the error was that it could not make transaction log of msdb, because it was set to SIMPLE.

    Why is it automatically set to simple? I read that when the sql agent restarts, it's set to simple, but how can i avoid this?

  • February 22, 2007 at 3:23 am

    #691096

    this is the default for msdb - think carefully about what you are asking, do you really need tran logs for msdb ?  As you only take two tran log backups per day, if you really want extra msdb data then schedule a differential backup of msdb.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 22, 2007 at 3:52 am

    #691107

    Hmm..ok, do I need to make trans logs of msdb? I run a full backup of it every night. Is it necessary with the trans logs of msdb?

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

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