Database File Restricted

  • 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

  • u can consider creating a second log file.

    ..>>..

    MobashA

  • Double-posting - follw the conversation over here:

    http://qa.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?

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

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

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