Category Archives: Sharepoint services

Reduce Sharepoint services 3.0 log.ldf files…

I had the problem that Sharepoint_Config-ID-.log.ldf grow realy BIG (14GB) on a content database of 1 GB!

You can solve this problem by using “Shrink” command in the MS SQL Server Management Studio Express

First you need to connect to your Sharepoint 3.0 database called: \.pipemssql$microsoft##sseesqlquery – just put this string in your “Server name” field:

\.pipemssql$microsoft##sseesqlquery

 Create full backup of all databases before continuing!

After that we should change restore mode from “Full” (this the parameter that allows .log.ldf to grow that large as transaction logs are not purged) to “Simple”:

Expand Databases, right mouse click on Sharepoint_Config… Properties, Options, Recovery model: Simple and click OK

Shrink the database procedure:

Expand Databases, right mouse click on Sharepoint_Config… Tasks, Shrink, Files in File type select Log and click OK
Your log file will become radicaly smaller. 🙂

Be sure you backup your databases before this procedure and also on daily bases…

Good luck!

 Also check:
http://geekswithblogs.net/RogueCoder/archive/2008/06/03/122588.aspx
http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Advertisements

Windows Sharepoint services z dodatnimi ikonami za datoteke z NE-Office končnicami. / Windows Sharepoint services with additional icons for NON-Office files extensions.

Večkrat so me uporabniki Sharepoint services vprašali zakaj Sharepoint ne zna prikazati določenih ikon “znanih” datotek. Spodaj si lahko poberete zip datoteko z ikonami, XML konfiguracijsko datoteko ter .BAT(ch) datoteko, ki vam vse avtomatsko instalira/integrira. Odslej boste v svojem sharepointu lahko imeli “lepe” ikone za PDF, Excel webquery file, ZIP, RAR ter DWG. / More than one I have been asked how to add or maybe why Sharepoint does not support some known file extensions icons. So I created a zip file with icons, XML configuration file and .BAT(ch) procedure for automatic install/integration of this new icons to your Sharepoint.

Povezave / links: http://www.microsoft.com/technet/windowsserver/sharepoint/default.mspx
http://msmvps.com/blogs/cgross/archive/2004/10/26/16679.aspx
http://www.kbalertz.com/kb_837849.aspx

Current version 1.0 supports // PDF, DWG, ZIP, RAR, IQY (Excell webquery file) //
Sharepoint icons 1.0.zip

Sharepoint services 2.0 / Office 2003 težava – Urejanje v podatkovnem listu ne deluje v določenih različicah … / Sharepoint services 2.0 / Office 2003 issue – Edit in datasheet does not work on some versions …

Spodnji članek opisuje težavo in rešitev: / The following article describes the problem and the solution:

http://wss.collutions.com/Lists/FAQ/DispForm.aspx?ID=253

Sharepoint datasheet problem.zip