Hi Guest

HomePage

1 1

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

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

Home >> 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...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript 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...




Other Important Questions
What is sharepoint and its overview
What are content types in sharepoint
difference between site definition and site template
Classes in share point client object model
Client Object Model in SharePoint 2010






Most Visited Questions
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |
     
 
Privacy policy | Terms and Conditions | Blog


If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)
 

1
Home About Us GroupChat
 
Sitemap Feedback Contact us