WSS_Content_log.ldf is too big and Shrink command caused to increase fruther
I looked all over the web regarding large wss_content_log.ldf file and the general recommendation was to shrink it. My current wss_content_log.ldf is 88 GB.
I logged in to SQL 2005 Management Studio expanded Databases, right clicked on Tasks>Shrink>Files. In Shrink windows properties I changed File Type to "log"
and it displayed the log files info as follow:
Currently Allocated Space: 88123.12 MB
Available Free Disk Space: 54123.00 (6%)
In the Shrink action I selected “release unused space” and clicked on the OK button.
Once operation was completed the log file increase to 92 GB.
Did I do something wrong????
Thanks…B
September 17th, 2011 4:59pm
Does this help ?
http://support.microsoft.com/kb/907511
Steve Thomas
Free Windows Admin Tool Kit Click here and download it now
September 18th, 2011 12:21am