ShareWebDb_log.ldf is 97GB - How to reduce?

Posted by pierre on Server Fault See other posts from Server Fault or by pierre
Published on 2012-09-13T16:15:28Z Indexed on 2012/09/17 9:40 UTC
Read the original article Hit count: 541

Filed under:

logging

|

windows-sbs-2008

|

wss

We run an SBS 2008 server with WSS. On the drive I have set aside for WSS, I'm fast running out of space due to the ShareWebDb_log.ldf file:

File size is huge compared to the actual sharepoint site (15 GB)

I've tried doing to do what I've read online - change the recovery mode, backup and truncate - but I can't actually see how I do this via the SQL Server Management Studio tool. Can anyone shed any light?

ShareWebDb_log.ldf is not listed in the databases list

The database for this file does not show in the list, and I cannot expand Management > SQL Server Logs (because it's too large?).

© Server Fault or respective owner

Related posts about logging

log file is not getting created using JDK logging with Commons-logging

as seen on Stack Overflow - Search for 'Stack Overflow'
When I run the TestJcLLoggingService class log messages are coming to Console but no log file is created, please help me if you know the answer. two source files are pasted below. TestJcLLoggingService.java package com.amadeus.psp.pasd.logging; import org.apache.commons.logging.Log; import org… >>> More
Python logging before you run logging.basicConfig?

as seen on Stack Overflow - Search for 'Stack Overflow'
It appears that if you invoke logging.info() BEFORE you run logging.basicConfig, the logging.basicConfig call doesn't have any effect. In fact, no logging occurs. Where is this behavior documented? I don't really understand. >>> More
Python: combine logging and wx so that logging stream is redirectet to stdout/stderr frame

as seen on Stack Overflow - Search for 'Stack Overflow'
Here's the thing: I'm trying to combine the logging module with wx.App()'s redirect feature. My intention is to log to a file AND to stderr. But I want stderr/stdout redirected to a separate frame as is the feature of wx.App. My test code: import logging import wx class MyFrame(wx.Frame): … >>> More
Redirect logging output using custom logging handler

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, I'm using a module in my python app that writes a lot a of messages using the logging module. Initially I was using this in a console application and it was pretty easy to get the logging output to display on the console using a console handler. Now I've developed a GUI version of my app… >>> More
Java Logger API

as seen on Oracle Blogs - Search for 'Oracle Blogs'
This is a more like a tip rather than technical write up and serves as a quick intro for newbies. The logger API helps to diagnose application level or JDK level issues at runtime. There are 7 levels which decide the detailing in logging (SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST)… >>> More

Related posts about windows-sbs-2008

Windows SBS 2008 problem: workstation login delays

as seen on Server Fault - Search for 'Server Fault'
Last week I had a problem with my server (Windows SBS 2008 ), so I made a restore point to resolve that problem. But after I did it any workstation (Windows 7) try to login takes 50 seconds. I tried to find an error in event viewer, but there are no errors. Can anyone help me? >>> More
windows sbs 2008 problem

as seen on Server Fault - Search for 'Server Fault'
hello last week i got problem with my server ( windows sbs 2008 ) so i make a restore point to resolve that problem , but after i did it any workstation( windows 7 ) try to login will take 50 second , so i tried to find an error in event viewer but there is no errors. can anyone help me >>> More
Windows SBS 2008 problem

as seen on Server Fault - Search for 'Server Fault'
I was today on clients site that has Windows 2008 SBS installed with Symantec EndPoint Protection. Problem is that after I logged in tried multiple commands like services.msc, msconfig typed in "Run" but nothing was started. For the first 5 minutes i can click around Start Menu, choose some applications… >>> More
Setting up Windows SBS 2008 network on Xen

as seen on Server Fault - Search for 'Server Fault'
I'm trying to install a Windows SBS 2008 server in a Xen environment. The OS is booting fine. Unfortunately I can't figure out how to set up the network settings. Dom0 is a Debian Lenny hosting around 10 virtual servers. Here are the settings I'm using in the hosted Windows SBS: IP address: 10… >>> More
SBS 2008 Backup Drive Full - Error Code '2147942512'

as seen on Server Fault - Search for 'Server Fault'
We are using Windows Backup on SBS 2008 SP2 and backing up to 1TB external hard drives. Recently after switching drives our backup started failing because the backup drive is full and auto-delete isn't automatically deleting older backups/show copies. I'm trying to get more information to help me… >>> More