MSDB Recovery Model

• Jan_Eyres

  Grasshopper

  Points: 21

  More actions

  January 22, 2004 at 10:29 am

  #82141

  I need to take Full backups of the MSDB database.

  I've noticed that when the SQL Server box is restarted the Recovery Model of the MSDB database keeps getting reset back to Simple.

  Any ideas on how I can stop this happening would be appreciated.

   

   

   

   

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  January 22, 2004 at 10:32 am

  #491159

  You can perform full backup to MSDB no matter it is in simple or full recovery mode.

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 22, 2004 at 1:02 pm

  #491200

  In addition to Allens' post this might be interesting http://support.microsoft.com/default.aspx?scid=kb;en-us;257856

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 23, 2004 at 2:27 am

  #491289

  You could place the commands to set msdb into a proc and run the proc at startup automatically.

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