Default database settings

• BigSam

  SSCrazy

  Points: 2146

  More actions

  January 3, 2008 at 8:42 am

  #177828

  I want to modify the default database setting for new databases. I've developers that do all sorts of cruel & unusual things on their servers & I want to simplify things for them & me. Specifically I want to change the Recovery Model from Full to Simple & the Data + Log Growth factors to 4 MB. I did not see these options in the Server Properties, where some settings are stored. Also, (call me crazy) but I believe these settings change are per user - I know it doesn't make sense, but I hear these things from my developers.

  Thanks

  BigSam

• Carolyn Richardson

  SSCrazy Eights

  Points: 8357

  More actions

  January 3, 2008 at 8:45 am

  #764401

  Just adjust the Model database with the settings you want and all new databases will have the same settings as the Model one.

  Facts are stubborn things, but statistics are more pliable - Mark Twain
  Carolyn
  SQLServerSpecialists[/url]

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 3, 2008 at 3:19 pm

  #764597

  or you create a script which runs through all your databases every night putting them to what you want.

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