Geeks With Blogs
Pankaj Tahiliani

Problem: I am using WSS 3.0 with SQL MSDE. I am having an issue on my  server. The system disk is becoming full in every week. I noticed that my sql server ldf (log files) is very big specially wss-server-configuration database logfile it is about 5.25 GB and there are other 3 databases, their log file sizes are approx 3 gb.

Is this recommended if I should shrink the log file, should I loss any data
here? If I shrink the databse, again it is on going process everytimg I need
to shrink the databse.

Please suggest what should I do?

Solution: Go to the properties of the database in SQL Enterprise Manager or Sql Server Management Studio.  Look around for "Recovery Model."  In 2005 it's in the Options page.  Set the Recovery model to Simple.

Then go Tasks and select "Shrink" database.

Posted on Tuesday, March 24, 2009 2:46 PM | Back to top

Comments on this post: WSS database Log files are too big

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Pankaj Tahiliani | Powered by: