Post reply

How To Increase Size of Log Files

  • October 12, 2010 at 9:09 am

    #157254

    Anyone know if it is possible to change the max size of the log files that SQL Server creates for the Error Log or the SQL Agent logs? I have found where you can change the number of these but I can't find a way to change the max size from what appears to be a default of (and I'm going form memory ) around 2048KB.

    I know you can't make any changes to the Default Trace log (or at least you could not in the past within SQL Server 2005) and so I am only trying to make this change to the other Log files created by SQL Server.

    Any input is most appreciated.

    Thanks

    Kindest Regards,

    Just say No to Facebook!

  • October 12, 2010 at 10:05 am

    #1235661

    Error logs will continue to grow throughout the uptime of the server instance. Therefore there is no maximum size. You may want to manually cycle them in periods of long uptime (which is what we want!)

    See the SSC article. [/url]

  • October 12, 2010 at 10:22 am

    #1235680

    AFAIK, MysteryJimbo is correct. I've had error logs grow into the GB, which makes looking through them hard. Typically I've cycled them every week or so in order to keep them at manageable size.

    Cycling them accomplishes the same thing as a max size since you need the log for SQL Server to work.

  • October 12, 2010 at 10:26 am

    #1235684

    I've seen one company cycle the logs files on every server everynight at midnight. This made searching the logs much easier that trying to do it with a log that has weeks of data in it.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 12, 2010 at 12:46 pm

    #1235799

    Alvin Ramard (10/12/2010)

    I've seen one company cycle the logs files on every server everynight at midnight. This made searching the logs much easier that trying to do it with a log that has weeks of data in it.

    We do that as we have around 2 - 3 million transactions per day.

  • October 12, 2010 at 1:27 pm

    #1235827

    Sorry to waste everyones time on this but the problem was user/tech error. Thats what I get for not doing it myself.

    Kindest Regards,

    Just say No to Facebook!

Viewing 6 posts - 1 through 5 (of 5 total)

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