Database File Restricted

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  March 5, 2008 at 2:54 pm

  #120261

  Hello Everyone

  I am having an issue with one of my databases. This is a database that came from a vendor in a canned package.

  The database log file is set to a restricted growth size. I have tried changing it to unrestricted, but it will not save that. I need to get the size higher and the percentage of growth lower. I cannot save these changes once I select the "OK" button. It goes back to the original settings of "Restricted"

  Had anyone ran across this before? How can I over come this fact and get around this. I need to be able to modify that setting.

  Thanks

  Andrew SQLDBA

• mobasha

  SSCertifiable

  Points: 5334

  More actions

  March 5, 2008 at 2:58 pm

  #785789

  u can consider creating a second log file.

  ..>>..

  MobashA

• Matt Miller (4)

  SSC Guru

  Points: 124210

  More actions

  March 5, 2008 at 3:03 pm

  #785792

  Double-posting - follw the conversation over here:

  http://www.sqlservercentral.com/Forums/Topic464117-146-1.aspx

  ----------------------------------------------------------------------------------
  Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

• Scalability Doug

  SSCertifiable

  Points: 5351

  More actions

  March 5, 2008 at 5:47 pm

  #785837

  Just curious, what is the "Max Size" set to?