首页 > 代码库 > 解决SharePoint_Config_log.ldf文件过大问题(转载)

解决SharePoint_Config_log.ldf文件过大问题(转载)

sharepoint 2010 数据库日志文件SharePoint_Config_log 太大了 36 g 压缩了下 搞到100M

方法:打开SQL Server Management Studio,查询窗口输入命令

USE SharePoint_Config;
GO

-- 将数据库设置为简单恢复模式,
ALTER DATABASE SharePoint_Config
SET RECOVERY SIMPLE;
GO

--压缩为100M
DBCC SHRINKFILE (SharePoint_Config_log, 100);
GO
-- 恢复
ALTER DATABASE SharePoint_Config
SET RECOVERY FULL;
GO

解决SharePoint_Config_log.ldf文件过大问题(转载)