How to Shrink the SharePoint database Log files

HomePage Jobs WalkIn Articles Group Chat Contact Us Feedback Sitemap

	To improves our performance please Like Share Subscribe(Will boost us)
	Follow

How to Shrink the SharePoint database Log files
Question Posted on 30 Nov 2015Home >> SharePoint >> SharePoint Interview >> How to Shrink the SharePoint database Log files

Below is the syntax to Shrink the SharePoint database Log files.

USE DatabaseName
GO
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY
DBCC SHRINKFILE(Transaction_Log_Name, 1)
GO

Example:-
USE Crakyourinterview
GO
BACKUP LOG Crakyourinterview WITH TRUNCATE_ONLY
DBCC SHRINKFILE Crakyourinterview_Log
GO

	0
	0


	.

	Most Visited Questions:-
	Deep Learning Questions Answers Below are the different Deep Leaning Questions and answer a More...
	What is Gulpjs and some multiple choice questions on Gulp Gulpjs is an open source whihc helps in building Javascript More...
	Continuous Integration Questions Answers Below are the 20 odd questions for CI or Continuous Integra More...
	Derived relationships in Association Rule Mining are represented in the form of __________. Derived relationships in Association Rule Mining are repres More...
	Microservices Architecture Questions Answers Below are the different questions on Microservices Architec More...

To improves our performance please Like Share Subscribe(Will boost us)