Stopzilla AVM

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

15 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. I have read your blog it was nice to follow even I am looking for your future updates.

    Angular training in chennai

    ReplyDelete
  5. 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
  6. IVR application for your call center or business for call inbound.....

    IVR services

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

    Dotnet Training

    ReplyDelete
  8. 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
  9. the blog is very nice and informative. thank you for sharing the blog with us. keep on updating.

    Java training in Chennai

    ReplyDelete
  10. 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
  11. 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
  12. 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
  13. 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
  14. By purchasing a Windows product key, you will receive a 100% Original Microsoft product key license .
    That can be activated directly on the official Microsoft website. Our secure payment methods give you a total guarantee,
    and you will receive your software by email after a few minutes of purchase.
    https://microprokey.com/

    ReplyDelete