Avatar of jmsjms
jmsjms
Flag 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.

THanks!
Microsoft SharePoint

Avatar of undefined
Last Comment
jmsjms

8/22/2022 - Mon
Jamie McAllister

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

http://www.sharepointboris.net/2008/10/sharepoint-config-database-log-file-too-big-reduce-it/

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

ASKER
Hi Jamie,

This doesnt help I'm afraid.  As I mentioned, shrink wont have any effect and it's already set to simple mode.
Jamie McAllister

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;

http://www.mssqltips.com/sqlservertip/1774/move-sql-server-transaction-log-files-to-a-different-location-via-tsql-and-ssms/
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
jmsjms

ASKER
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.

Thanks
John
ASKER CERTIFIED SOLUTION
jmsjms

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
jmsjms

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