1.

How to Shrink the SharePoint database Log files

Answer»

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


Discussion

No Comment Found

Related InterviewSolutions