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.
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.
Click on Files.
Select File type : Log
Click OK.
You will see the log file size is reduced in KBs.
Thanks
A special thanks for this informative post. I definitely learned new stuff here I wasn't aware of !
ReplyDeleteWow thanks for sharing your knowledge & experience with us, its very interesting to read
ReplyDeleteWeb design training in Chennai
ReplyDeleteThanks for sharing your view to our knowledge’s, its helps me plenty keep sharing…DOT NET Training in Chennai
ReplyDeleteI have read your blog it was nice to follow even I am looking for your future updates.
Angular training in chennai
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?
ReplyDeleteNice article!!! your info is to good.....
ReplyDeleteDevelop Android App
IVR application for your call center or business for call inbound.....
ReplyDeleteIVR services
Really nice information here. I got some valid information from this valuable content. Please keep update with this site.
ReplyDeleteDotnet Training
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.
ReplyDeleteSAP training in Chennai
the blog is very nice and informative. thank you for sharing the blog with us. keep on updating.
ReplyDeleteJava training in Chennai
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.
ReplyDeleteThis blog provides useful information about new techniques and concepts.very impressive lines are given which is very attractive.
ReplyDeletejava training in chennai thiruvanmiyur
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.
ReplyDeleteSalesforce Training in Chennai Mylapore
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.
ReplyDeleteDigital Marketing Company in Chennai
By purchasing a Windows product key, you will receive a 100% Original Microsoft product key license .
ReplyDeleteThat 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/