EnjoySharePoint YouTube Channel

How to shrink transaction log files in SharePoint 2013?


In this post, we will discuss how we can shrink transaction log files in SharePoint 2013. If transaction log files DB is full you will receive an error while doing few operations in SharePoint 2013.

Get Office 365 Enterprise E3 Or Business Premium Subscription & Try out all the features

Also, read:
View ULS Logs using SharePoint LogViewer in SharePoint 2013


Managed Path in SharePoint 2013

Get Current Logged in User and Display Name using SharePoint 2013 REST API

Follow below steps to resolve the issue which I followed from this article

Open your SQL Server management studio then run the below statements:

ALTER DATABASE UrDBName SET RECOVERY SIMPLE

Then Run Below statement:

DBCC SHRINKFILE (UrDBName_Log, 5);

Then run

ALTER DATABASE UrDBName SET RECOVERY FULL;

Hope this will be helpful.

Check out Best Alternative to InfoPath -> Try Now
You May Also like the Following SharePoint Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →