SharePoint: SharePoint_Config_Log.ldf file size taking up too much space.

 

Location of the file:

C:Program FilesMicrosoft SQL ServerMSSQL10_50.SHAREPOINTMSSQLDATA

The File: Share_Point_Config_Log.ldf

 

 

1. Open up Microsoft SQL Server Management Studio
2. New Query
3. Type in the following and press execute:

USE [master]
GO
ALTER DATABASE[SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT
GO
USE [SharePoint_Config]
GO
DBCC SHRINKFILE (‘SharePoint_Config_Log’)
GO

 

Tags:

Comments are closed

Latest Comments

No comments to show.