Hi Guest

MobileUser

1 HomePage 1 Jobs 1 WalkIn 1Articles  

Cat Exam

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 


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



 
 Input Your Comments Or suggestions(If Any)
 Name
 Email(optional)
 Comments


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






 
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 |