StateService数据库的大小太大 [英] The size of the StateService database is too large

问题描述

Hello， 

我们的stateservice数据库太大，超过500GB这是mdf文件。微软的文章称通过创建另一个状态服务数据库来扩展。我们可以创建另一个数据库但是有没有办法减小尺寸？我有什么选择？我们可以在创建新的StateService数据库后删除
旧的mdf文件吗？ 

谢谢

解决方案

Hello Danny

是LDF吗？或MDF占用了相当大的空间？  如果它只是LDF，请将恢复模型设置为简单，然后
缩小日志文件。

另外，请参阅以下文章以供参考。

https://social.technet.microsoft.com/Forums/Windows/en-US/afbe45e7-7b67-49a7-93db-353b74f8ce1f/reducing-the-size -of-stateservice-database？forum = sharepointgeneralprevious

Hello, 

Our stateservice database is too large like over 500GB It is mdf file. Microsoft article says scale out by creating another state service database. We can create another database but is there any way to reduce the size? What are my options? Can we just delete the old mdf file once we create the new StateService Database? 

Thank You

解决方案

Hello Danny

Is it the LDF or MDF that is taking a considerable amount of space?  If it is just the LDF, set the Recovery Model to Simple, then shrink the Log file.

Also, find the below article for your reference.

https://social.technet.microsoft.com/Forums/Windows/en-US/afbe45e7-7b67-49a7-93db-353b74f8ce1f/reducing-the-size-of-stateservice-database?forum=sharepointgeneralprevious

这篇关于StateService数据库的大小太大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！