Archive for the ‘Sharepoint services 3.0’ Category

Reduce Sharepoint services 3.0 log.ldf files…

Sunday, June 15th, 2008

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: \\.\pipe\mssql$microsoft##ssee\sql\query – just put this string in your “Server name” field:

\\.\pipe\mssql$microsoft##ssee\sql\query

 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

Change password in sharepoint (webpart)

Tuesday, January 1st, 2008

http://www.itacs.de/services/ChangePwEn.aspx – if Sharepoint users are in Active directory
http://www.itacs.de/services/ChangeLocalPwEn.aspx – if users are not in Active directory
Tested on Sharepoint services 2.0 and Sharepoint services 3.0 (installed with stadm – see readme.txt)

Sharepoint3.0 / WSS3.0 incoming mail limitation with Excnhange 2003 / SBS2003

Sunday, February 11th, 2007

http://channel9.msdn.com/ShowPost.aspx?PostID=258392

In web development , the website design will remain void only if the web hosting deal is actually a dedicated hosting.