SELECT NAME, recovery_model_desc FROM sys.databases
经检查发现sharepoint的状态数据库日志文件很大,有78G,因此缩减状态数据库日志文件到500M,具体操作如下:
ALTER DATABASE StateService_fe3a026d155a4852b906c8f3735cdcd3 SET Recovery simple
go
use StateService_fe3a026d155a4852b906c8f3735cdcd3
go
DBCC SHRINKFILE(StateService_fe3a026d155a4852b906c8f3735cdcd3_log,500)
go
最终实现的效果,如下图: