Best way to change initial log size of a live db?

  • Hello,

    We have a DB who's log-size is set to 16GB as the "initial size", the log is 99% free space, but I cannot release this space as the initial size is set so high.

    Ultimately, I want to change this to about 100MB as there is no reason for it to be this large.

    What is the best approach to do this?

    I tried to just change the Initial Size from the Properties window, but this does not work.

    Any help appreciated.

    Thank you.

  • You could shrink the log file first and then set it to what you want.

  • use dbcc shrinkfile to shrink the logfile.

    Warning:

    Many times the logfile is the size it is for a reason...

    whether it's logging reindexes or what have you.

    If you're really concerned about the size of the log file and you understand the ramification of changing your database's recovery model, you might consider changing it to one of the 2 types that are geared toward minimizing the log file size.

    Be careful, though. You'll limit your ability to perform a point-in-timer recovery if you change the recovery model to simple or bulk-logged. That's OK in some cases but be SURE this is what you want.

    ~Craig

  • Have you check how full your log file is after rebuilding indexes?

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

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