26 Responses to “Reduce Sharepoint services 3.0 log.ldf files…”

1. Fabian Tuender says:

   26 June, 2008 at 19:21

   Great, this was the information I was looking for. I knew how to shrink the database but has problems accessing the server. Thanx to your servername string I was able to connect. Thanx!
2. Dannel says:

   2 October, 2008 at 14:13

   Hey thanks so much for this, you are the man!

   Really helped me out of a hole cheers again!
3. Jeff says:

   6 October, 2008 at 15:55

   thanks for the server string
4. Matt says:

   28 October, 2009 at 20:48

   How would i connect to it if it was a remote server?
5. Admir says:

   23 November, 2009 at 4:38

   Hi Luka, thank you for this posting. I had a same problem …. Sorry not any more . The servser connection string is magic …
6. mohit says:

   7 January, 2010 at 12:28

   Thank you! you explained it in very simple words. It worked for me and saved us from potential downtime and few sleepless nights. — Regards
7. Rodney says:

   7 April, 2010 at 5:16

   Thanks Luke! you saved me 8Gig in 30 seconds and good timing as my drive was sitting at 200mb free space

   Also a mention to Google for finding the page for me…

   Awesome.
8. MR says:

   9 April, 2010 at 8:39

   THANK YOU VERY MUCH ! this solved my problem completely… Thank you again.

   best regards from MALAYSIA
9. Marc says:

   28 May, 2010 at 21:43

   cheers, you are a champ!
10. Christian H. says:

    13 June, 2010 at 11:43

    Sounds like a nice solution, but what if I get “Login Failed” – I am logged in to Windows with the only Windows Admin account. This is the standard SBS 2008 installation, can’t think of ever having set any Admin passwords for the WSS database.
11. manojlovicl says:

    20 June, 2010 at 23:17

    For those with problems on SBS 2008 check this link: http://support.microsoft.com/kb/2000544
12. CIU says:

    25 August, 2010 at 13:50

    Excellent solution! We had our logs on SharePoint_Config getting up to 17gigs and our WSS_Content up to 35gigs. Ran the shrink file on both databases and now logs nearly at 0. Also thanks for the correct database string path.
13. Robi says:

    27 September, 2010 at 19:05

    Sem srinkal na WSS content in Config. Mi je re?ilo prostorsko stisko.

    Hvala
14. TX IT Guy says:

    12 October, 2010 at 19:27

    Thank you, thank you, thank you!

    I have gone through dozens of websites that were longer and no help, this is exactly the information I needed!
15. Rob says:

    22 November, 2010 at 12:10

    This SAVED ME. HERO thanks
16. Verret says:

    30 January, 2011 at 18:27

    Wonderful. Saved my life

    Thank’s a lot!
17. Jsmith says:

    26 May, 2011 at 18:47

    This worked on the ShareWebDB database but when i tried to go to the properties of the Sharepoint_Config database i get and SQL error that says:
    Property Owner is not available for Database ‘[SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6]‘. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Express.Smo)

    This appears to be the same error on other of servers.
18. manojlovicl says:

    26 May, 2011 at 23:54

    You shuld run SQL management as administrator / right click / run as administrator
19. jsmith says:

    27 May, 2011 at 4:55

    Same error running as administrator logged into server as administrator
20. dotNetFollower says:

    6 August, 2011 at 2:47

    Hello!
    Here is the almost same way to shrink sharepoint database transaction log.
    Thanks!
21. Mike says:

    17 October, 2011 at 20:20

    Thanks! This really helped, I was down to 2GB of disk space.
22. Steven says:

    9 January, 2012 at 8:04

    Brilliant. Thanks!
23. Leif Stenfeldt says:

    21 March, 2012 at 10:41

    You are my hero – thanks for sharing your knowledge.
24. Alan says:

    13 April, 2012 at 9:57

    How do you “connect” to the SharePoint database? When I open SQL studio, the only db listed is my Antivirus one, and when I do File-> Connect, the only db’s I can browse to are other SQL instances installed by 3rd party apps, or SBS Monitoring: the SharePoint DB is not listed. Help! this is so frustrating! My C drive is almost out of pace due to 20GB ldf file, and I’ll need to forcefully remove SharePoint completely if I can’t get rid of the stupid ldf file.
25. Dave says:

    1 November, 2012 at 16:43

    By far the best thing to happen to my job! You just freed up over 20GB with just this. Thank you, thank you, thank you!
26. Grant says:

    11 December, 2012 at 22:26

    Thanks a lot for the \\.\pipe\mssql$microsoft##ssee\sql\query information! None of the other dozen or so articles I found mentioned this, and I had no idea how to access the database.