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 error while doing few operations in SharePoint 2013.
– 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);
ALTER DATABASE UrDBName SET RECOVERY FULL;
Hope this will be helpful.