February 8, 2010 at 11:47 am
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.
February 8, 2010 at 12:01 pm
You could shrink the log file first and then set it to what you want.
February 8, 2010 at 12:39 pm
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
Craig Outcalt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply