tag:blogger.com,1999:blog-626496044417949674.post7874969762130289686..comments2023-10-23T02:47:16.202+11:00Comments on There is no place like 127.0.0.1: Shrinking the Sharepoint Config DB Log fileFelix Burkhardhttp://www.blogger.com/profile/09399141730969360190noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-626496044417949674.post-77684314492948342762015-04-27T19:23:54.028+10:002015-04-27T19:23:54.028+10:00Thanks for this, i was unable to detact the SUSDB,...Thanks for this, i was unable to detact the SUSDB, ran your query and it fixed our issue. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-35192252769490797032013-05-23T20:03:56.673+10:002013-05-23T20:03:56.673+10:00I worked six hours a day persisted. simply believe...I worked six hours a day persisted. simply believed would be resolved. it was thanks to you. thank you very muchLevent Kubilayhttps://www.blogger.com/profile/07127087381504702436noreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-51896487401968452722013-04-25T20:21:02.607+10:002013-04-25T20:21:02.607+10:00this site is actually useful compared to the other...this site is actually useful compared to the others out there referencing the same problem<br /><br />thanks for sharing!<br /><br />MrMAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-70954441010124018812013-03-26T03:36:44.329+11:002013-03-26T03:36:44.329+11:00Thank You, the scripts opened 16 Gigs of space on ...Thank You, the scripts opened 16 Gigs of space on the server I was working on. A real life saver!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-25910183855242931502012-07-17T10:33:52.278+10:002012-07-17T10:33:52.278+10:00This saved a customer of mine around 4.5GB of disk...This saved a customer of mine around 4.5GB of disk space on their system drive, thank you!Brenton Crosbyhttps://www.blogger.com/profile/09868971863958582031noreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-4459781462889387642012-04-07T04:52:24.087+10:002012-04-07T04:52:24.087+10:00Thank you for this post!! I've been trying to...Thank you for this post!! I've been trying to understand what's going on. My log was 20GB and growing by the hour!! I'm not familiar with this db or what makes it grow, but I'll keep an eye via the reports!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-59986895051597342932011-02-19T12:50:46.704+11:002011-02-19T12:50:46.704+11:00Hi Chris
Thanks for the feedback, I am glad the s...Hi Chris<br /><br />Thanks for the feedback, I am glad the script helped you out. <br /><br />Your site must be very busy? What is the size of the actual DB file? It indicates something fishy going on... Have a look at the reports you can get from the DB; just right click on the Share Point config database, then select Reports > Standard Reports and pick any one of them. It may help to narrow down what is happening.<br /><br />Good luck!Felix Burkhardhttps://www.blogger.com/profile/09399141730969360190noreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-30866771741617955802011-02-18T03:02:21.525+11:002011-02-18T03:02:21.525+11:00I'm going to link to this post, great info. I ...I'm going to link to this post, great info. I have a script that does sort of the same thing in a different way, though yours is much better and far easier to implement and maintain. I was at 7Gb, now down to under 1.<br /><br />My continuing problem is that the log file grows and grows, and it will be back up to 7+ Gb in two days. Maybe i have usage tracking or something enabled. I removed all of my column indexing, well see how it goes.<br /><br />Thanks again :)Chris Dillhttp://smartbserver.netnoreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-89743127723263137152010-09-24T16:29:34.929+10:002010-09-24T16:29:34.929+10:00Fantastic job - And the funny part was, that I did...Fantastic job - And the funny part was, that I didn't even have to change my DB name - it was the same as yours!!<br /><br />I had been googling around for a long time, to solve this. And this nice little script did it. <br /><br />Thanks a bunch. <br /><br />KimAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-626496044417949674.post-44510592145896212152010-08-21T23:22:31.028+10:002010-08-21T23:22:31.028+10:00Thans! I don't normally post on these kinds of...Thans! I don't normally post on these kinds of things, but it was nice and concise here and saved me much time... for the record, my DB file was the same name, so perhaps that's a standard? In any case, mine was also pegged at 11GB, and now it is at a nice even 50MB as your script makes. Thanks again!Anonymousnoreply@blogger.com