Windows Sharepoint Services V3 - Log files

Dangerous · 14 Feb 2008 at 10:57

Does anyone know how to commit the logs in WSS?

WSS_Content DB file is 10GB
WSS_Content Logs file is 28GB?

We backup using "stsadm -o backup -url http://vrssvrapp02 -filename e:\splive.dat -overwrite"

Dangerous · 15 Feb 2008 at 10:22

Hmm anyone? Google has also failed me - I can find Sharepoint portal stuff but its not a proper SQL DB

Fr0dders · 15 Feb 2008 at 11:11

what are you trying to do, clean them up and prune old logs ? or backup the entire logfile ?

Dangerous · 15 Feb 2008 at 11:17

We can't work out why the log files are larger than the DB - And we are running out of space

14/02/2008 22:11 11,918,311,424 WSS_Content.mdf
10/02/2008 11:01 29,013,639,168 WSS_Content_log.LDF

Fr0dders · 15 Feb 2008 at 11:37

i see your point

28gb's worth of logs is a lot. are they plain text so you can see whats happenning ?

Dangerous · 15 Feb 2008 at 11:42

Not tried opening them as it probably would crash my PC/Server if I try to open almost a 30GB text file

Fr0dders · 15 Feb 2008 at 12:35

equally good point.

not got my thinking hat on.

are we wanting to troubleshoot the reason why they'r so large, or just clear out the old stuff to keep them to a reasonable size ?

Dangerous · 15 Feb 2008 at 12:46

haha both - Why the hell is the log file larger then the DB and how the hell to I commit it to the DB

Padders · 15 Feb 2008 at 14:06

What do you mean by commiting the logs?

Dangerous · 15 Feb 2008 at 14:17

Information is normally put into the log files and once you do a back it commits all the log files into the SQL DB

Padders · 15 Feb 2008 at 14:33

No, your backup solution should be truncating the log files once backed up. The log data isn't incorporated into the actual DB.

Dangerous · 15 Feb 2008 at 14:39

stsadm is only of the only tools that does backup Windows Sharepoint services and this doesnt do it so thats why I'm looking for a fix.

Padders · 15 Feb 2008 at 15:06

But the content db and associated logs are managed by an instance of SQL Server (perhaps SSEE) your server backup solution should be truncating the log files - or you can do it manually via dbcc or a truncate only backup.

Fr0dders · 15 Feb 2008 at 15:46

this is what i found while googling, that the sharepoint logs get very big, and its normal practice to get a backup solution that truncates them.

need to find an example of a sharepoint backup solution that does this. No point in keeping 28gbs worth of log file.

Dangerous · 18 Feb 2008 at 09:36

Right sorted - Installed SQL Express management studio - Connected to the DB with the following "\\.\pipe\mssql$microsoft##ssee\sql\query"

Once in there you can either do a backup within the studio or using the "stsadm -o backup -url http://vrssvrapp02 -filename e:\splive.dat -overwrite"

Right click on WSS_Content and pick shrink. (Not sure if you have to put the DB into "Simple" mode before - I did and tried the SQL backup; that didn't work so did the shrink and that worked so not 100% you need it in simple mode.)

Butters · 18 Feb 2008 at 09:58

You can crop a log file by telling it to open only the first 100 lines irrespecitve of its size. Glad you got it sorted.