Right-click: SQL Server Management Studio (2008 R2) – and “Run as administrator”
Server type: Database Engine
Server name: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Authentication: Windows Authentication
Start “New Query” and add following 5 lines (adjust the content accordingly to your config filename):
USE “SharePoint_Config_aaaaaaaa-bbbbbbbbb-cccc-dddddddddddd”
GO
DBCC SHRINKFILE(“SharePoint_Config_aaaaaaaa-bbbbbbbbb-cccc-dddddddddddd_log”, 1)
BACKUP LOG “SharePoint_Config_aaaaaaaa-bbbbbbbbb-cccc-dddddddddddd” WITH TRUNCATE_ONLY
DBCC SHRINKFILE(“SharePoint_Config_aaaaaaaa-bbbbbbbbb-cccc-dddddddddddd_log”, 1)
!Execute
