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 !!!

6 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