Sunday, November 10, 2013

The transaction log for database 'Sharepoint_Config' is full

The above problem i faced serveral times earlier and that lead me to post it here for someone who is looking for solution.

Solution : 

1. On your SQL Server -> open the SQL Server Management Studio.

2. Connect to the local SQL Server

3. Right click SharePoint_Config -> Properties -> Options.  Change Recover Model from Full to Simple.

4.  Click OK.

5. Right click SharePoint_Config, go to Tasks -> Shrink -> Shrink Files.  Select a File type of Log, then Shrink

This should solve the problem.

Thank you !!!

27 comments:

  1. I like what you guys are up too. Such intelligent work and reporting!Keep up the excellent works guys I have incorporated
    sharepoint administrator training

    ReplyDelete
  2. In SharePoint, these are the steps you could implement to be SharePoint experts. Also find best SharePoint 2013 Certification Training in your locality at StaygreenAcademy.com

    ReplyDelete
  3. I have been following you for a couple of months now but this is my first time commenting on a blog post. Thank you for sharing your knowledge and experience with us. Keep up the good work. Already bookmarked for future reference.
    Hadoop Training in Chennai
    Hadoop Training
    Best Hadoop Training in Chennai
    Best Hadoop Training Institute in Chennai

    ReplyDelete
  4. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Digital Marketing Company in India
    seo Company in India

    ReplyDelete
  5. This post is really nice and informative. The explanation given is really comprehensive and informative.. iOS App Development Company in Chennai

    ReplyDelete
  6. Great site for these post and i am seeing the most of contents have useful for my Carrier.Thanks to such a useful information.Any information are commands like to share him.

    Salesforce Training in Chennai

    ReplyDelete
  7. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Custom SharePoint development Services

    ReplyDelete
  8. Thank you for taking the time and sharing this information with us. It was indeed very helpful and insightful while being straight forward and to the point.
    Salesforce Training in Chennai
    German Classes in Chennai
    Salesforce Admin Training in Chennai
    Salesforce Training Chennai
    German Courses in Chennai
    best german classes in chennai

    ReplyDelete
  9. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    online Python training
    python training in chennai

    ReplyDelete
  10. Have you been thinking about the power sources and the tiles whom use blocks I wanted to thank you for this great read!! I definitely enjoyed every little bit of it and I have you bookmarked to check out the new stuff you post
    Java interview questions and answers

    Core Java interview questions and answers

    Java training in Chennai | Java training in Tambaram

    Java training in Chennai | Java training in Velachery

    ReplyDelete
  11. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    Devops Training courses
    Devops Training in Bangalore
    Best Devops Training in pune
    Devops interview questions and answers

    ReplyDelete
  12. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    python Online training in chennai
    python Online training in bangalore
    python interview question and answers

    ReplyDelete
  13. A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.
    Java training in Chennai

    Java training in Bangalore

    ReplyDelete
  14. Excellant post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Devops Training in Bangalore
    Best Devops Training in pune
    Microsoft azure training in Bangalore
    Power bi training in Chennai

    ReplyDelete
  15. I am really very happy to find this particular site. I just wanted to say thank you for this huge read!! I absolutely enjoying every petite bit of it and I have you bookmarked to test out new substance you post.
    Data science training in bangalore

    ReplyDelete
  16. Very nice post here and thanks for it .I always like and such a super contents of these post.
    Excellent and very cool idea and great content of different kinds of the valuable information's.

    Java training in Bangalore



    ReplyDelete

  17. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.
    microsoft azure training in bangalore
    rpa training in bangalore
    best rpa training in bangalore
    rpa online training

    ReplyDelete
  18. I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing..
    Believe me I did wrote an post about tutorials for beginners with reference of your blog. 




    Selenium training in bangalore
    Selenium training in Chennai
    Selenium training in Bangalore
    Selenium training in Pune
    Selenium Online training

    ReplyDelete
  19. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    Devops Training in Chennai | Devops Training Institute in Chennai

    ReplyDelete