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

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

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

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

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

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.

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