How to Shrink the SharePoint database Log files

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) 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 |

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)