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
Comments are closed