Reduce Sharepoint services 3.0 log files

By | April 10, 2015
0 Comment

Reduce SharePoint 3.0 log files

I resent had a SharePoint server with a 80 GB hard drive that was running out of space. When I was called to look at the system, the free space was a total of 100 MB.

You can solve this problem by using “Shrink” command in the MS SQL Server Management Studio Express

First you need to connect to your SharePoint 3.0 database.

Just put this text in your “Server name” field:

\.pipemssql$microsoft##sseesqlquery

 

*WARNING* Create a full backup of all databases before continuing!

After your full backup has been complete, you should change the mode from “Full” (this the parameter that allows the LDF file to grow because the transaction logs are never purged) to “Simple”:

  • Expand the Databases
  • Right mouse click on SharePoint_Config…
  • Properties
  • Options
  • Recovery model: Simple
  • Click OK

Shrink the database:

  • Expand the Databases
  • right mouse click on SharePoint_Config…
  • Tasks
  • Shrink
  • Files in File type
  • Select Log
  • Click OK

The log files will drastically shrink.  You should now have 80% of your drive free.

I hope this helps!