Link to home
Start Free TrialLog in
Avatar of jmsjms
jmsjmsFlag for United Kingdom of Great Britain and Northern Ireland

asked on

How to clear/reduce size of Sharepoint Foundation 2010 Logging database

Hi Experts,
I've been working on our Sharepoint Foundation 2010 database, moving databases from one SQL server to another.  Since I've moved the logging database (WSS_Logging) it's grown to 2.8GB.  It was less than 33MB on its original SQL database server.

How can I clear it down?

Can I set a limit for this logging?  Is so how?

I'm already running it in SQL simple Recovery Mode and using SQL shrink wont work as there's not much free space in the Database.

Avatar of Jamie McAllister
Jamie McAllister
Flag of Switzerland image

Initial reduction can be done like this through UI or commands;

You can also change the recovery model to simple if that suits your environment and that will limit growth in future.
Avatar of jmsjms


Hi Jamie,

This doesnt help I'm afraid.  As I mentioned, shrink wont have any effect and it's already set to simple mode.
I cant believe that none of the shrink methods work for you. If not the UI then DBCC Shrinkfile or the other method should do something for you.

Beyong the above I can only suggest you move the files to another physical drive with more space;
Avatar of jmsjms


Hi Jamie,
A shrink will only work if there is free space available in the database or log.   Currently there is only 5MB free out of a 2.8GB main data file with a negligible log file.

Has anyone got another other suggestion on how to reduce the size of the Sharepoint Logging database?

If not, I'll just delete the database and set it up again.

Avatar of jmsjms
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jmsjms


This fixed the issue.  Shrinking the database did not work.