Tuesday, June 18, 2013

Shrink MS SQL Server log files

I have SharePoint farm running on my machine. Have memory and space limitations. In this situation most of the time receive alert running out of space. After investigation find that SharePoint Content database log files are taking lots of space in GBs.

So, you can reduce log files size through SQL server management studio. just need to follow some simple steps.

Navigate to physical location where SQL server files are stored. Path will be : C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA

You can recognise, files those have _log in the end are log files. And file type of these files are “SQL Server Database Transaction Log File”.  Here I’ve got one WSS_Content database file which I will find in SQL server management studio.

 

DatabaseLogFile

 

Now I open SQL server management studio and look for above file.

and here it is. Right click on database file navigate to Task > Shrink > Files.

 

ShringMenu

 

Click on Files.

Select File type : Log

 

LogFile

 

Click OK.

You will see the log file size is reduced in KBs.

 

Thanks

27 comments:

  1. A special thanks for this informative post. I definitely learned new stuff here I wasn't aware of !

    ReplyDelete
  2. Wow thanks for sharing your knowledge & experience with us, its very interesting to read
    Web design training in Chennai

    ReplyDelete

  3. Thanks for sharing your view to our knowledge’s, its helps me plenty keep sharing…DOT NET Training in Chennai

    ReplyDelete
  4. This is a wonderful informative blog here i learned many things in my interested domain keep posting...
    JAVA Training in Chennai|JAVA Training Institutes in Chennai

    ReplyDelete

  5. I have read your blog it was nice to follow even I am looking for your future updates.

    Angular training in chennai

    ReplyDelete
  6. But will you suggest this to be done in Enterprise Environments, where modifying anything at SQL level will take away the SLA for services and support?

    ReplyDelete
  7. IVR application for your call center or business for call inbound.....

    IVR services

    ReplyDelete
  8. Really nice information here. I got some valid information from this valuable content. Please keep update with this site.

    Dotnet Training

    ReplyDelete
  9. I read your articles very excellent and the i agree our all points because all is very good information provided this through in the post. It is very helpful for me. Keep blogging like this. Thanks.


    SAP training in Chennai

    ReplyDelete
  10. the blog is very nice and informative. thank you for sharing the blog with us. keep on updating.

    Java training in Chennai

    ReplyDelete
  11. Well, I read this information first time in your blog.local marketing seo That was a great research, it really nice and amazing one dear.

    ReplyDelete
  12. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.


    SAP training in Chennai

    ReplyDelete
  13. Thanks for the good words! Really appreciated. Great post. I ve been commenting a lot on a few blogs recently, but I had nt thought about my approach until you brought it up.

    SAP training in Chennai

    ReplyDelete
  14. This idea is mind blowing. I think everyone should know such information like you have described on this post. Thank you for sharing this explanation.Your final conclusion was good. We are sowing seeds and need to be patiently wait till it blossoms.

    Digital marketing company in Chennai

    ReplyDelete
  15. Great! Thanks for sharing the information. That is very helpful for increasing my knowledge in this fiel
    Red Ball | | duck life | Slitherio
    Red Ball 2 | Red Ball 3 | Red Ball 4

    ReplyDelete
  16. Great and useful article. Creating content regularly is very tough. Your points are motivated me to move on.


    SEO Company in Chennai

    ReplyDelete
  17. This blog provides useful information about new techniques and concepts.very impressive lines are given which is very attractive.
    java training in chennai thiruvanmiyur

    ReplyDelete
  18. wow great,nowadays this type of blog is more important and informative technology,it was more impressive to read ,which helps to design more in effective ways.


    Salesforce Training in Chennai Mylapore

    ReplyDelete

  19. Excellent incredible blog layout! How long have you been blogging for? you make running a blog look easy. The overall glance of your website is magnificent, let alone the content!

    Corporate Training in Chennai

    ReplyDelete
  20. Your content is awesome . You have done a great job and its very useful for me . I appreciate your effort and I hope that you will get more positive comments from the web users.
    SMO Services Chennai

    ReplyDelete
  21. Really an awesome post. I wondered by reading this blog post. Thanks a lot for posting this unique post which you have shared with us. Keep on posting like this exclusive post with us.

    Branding Services in Chennai

    ReplyDelete
  22. Wowwww... really great information. Having interesting topic. The pictorial representation helps me to easy understanding of this. Have a great idea. Thank you.
    SEO Company in Chennai

    ReplyDelete
  23. This blog is having a wonderful talk. The technology are discussed and provide a great knowledge toall. This helps to learn more details about technology. All this details are important for this technology. Thank you for this blog.
    Digital Marketing Company in Chennai

    ReplyDelete
  24. Thanks for sharing the valuable information here. So i think i got some useful information with this content. Thank you and please keep update like this informative details.

    SEO Company in India|Digital Marketing Company in Chennai

    ReplyDelete