Post reply

Recovery Model resets to Simple for MSDB on reboot

  • February 12, 2004 at 9:59 am

    #107535

    Currenly we have our MSDB recovery set to full on SQL Server 2000 sp1. Whenever the box is rebooted the recovery model is set back to simple. Is there a way to insure after a reboot the recovery model stays at full?

     

    Thanks,

    Kat

  • February 12, 2004 at 10:05 am

    #493843

    Use sp_procoption to set stored procedure to autoexection runs every time SQL Server is started. In the stored procedure, run alter database command to set database in full recovery mode.

  • February 13, 2004 at 8:50 am

    #494009

    From Microsoft "By default, the trunc. log on chkpt (ie Simple in SQL 2000)database option is set for the SQL Server msdb system database. This helps ensure that the transaction log of the database does not fill up, and prevents problems that may occur due to missing log space in the msdb system database. Because the msdb system database generally remains rather small, full database backups provide a fast alternative to transaction log backups for this database."

    Just a thought that you may want to consider leaving msdb as Simple recovery and back it up  using Full backups rather than transaction logbackups.

    Francis

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

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