Monday, 18 July 2011

SharePoint Config database log file too big. Solve it! :)

USE SharePoint_Config
GO
ALTER DATABASE SharePoint_Config SET RECOVERY SIMPLE
DBCC SHRINKFILE(N'SharePoint_Config_log', 1)
ALTER DATABASE SharePoint_Config SET RECOVERY FULL
GO

1 comment:

  1. Nice post...For further details of all the steps visit my blog:
    http://shareyourpoint.wordpress.com/2013/03/22/how-to-manage-large-sharepoint-configuration-database-logfile/

    ReplyDelete