Tuesday, 10 September 2013

SharePoint database Maintenance

USE [SharePoint_Config]
GO
ALTER DATABASE [SharePoint_Config] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE('SharePoint_Config_log', 100)
ALTER DATABASE [SharePoint_Config] SET RECOVERY FULL WITH NO_WAIT  
GO