欧非资源网:安全、免费、专业放心的资源下载站! 最新软件|软件分类

您的位置:欧非资源网 > 其他专区 > SharePoint > How to Shrink SharePoint Content Database Log File?

How to Shrink SharePoint Content Database Log File?

时间:2020-09-08 12:20作者:admin来源:未知人气:251我要评论(0)

一般情况下,企业SharePoint Farm启用后,随着时间增长和用户的频繁使用,SharePoint中的数据会越来越多,那么更好的优化存储数据的SQL Server空间便成了企业IT Admin需要考虑的问题。

我们都知道存储SharePoint的Content Database分两个DB文件,data和log file,有时候我们会发现Log的日志文件会达到几G甚至更多,这个时候就需要考虑在不影响SharePoint使用、不影响现有数据的情况下进行清理。

How to Shrink SharePoint Content Database Log File?

 

我们来看下如何清理SharePointdata的日志文件:

  1. 登录到SharePoint关联的SQL Server,用Admin Login;

How to Shrink SharePoint Content Database Log File?

  1. 找到要清理Log file的Content Database,右键在弹出菜单中点击Properties;

How to Shrink SharePoint Content Database Log File?

  1. 弹出的窗口中选择Options,在Recovery Model中下拉菜单中选择Simple,点击OK保存修改;

How to Shrink SharePoint Content Database Log File?

  1. 此时选择刚设置过Properties的Content Database,右键在Tasks->Shrink->Files点击;

How to Shrink SharePoint Content Database Log File?

  1. 在File Type中选择Log,下面Shrink action中选择“Reorganize pages before releasing unused space”并填写shrink file to的大小,点击OK保存;

How to Shrink SharePoint Content Database Log File?

此步骤也可以使用New Query执行:

选择对应的Database,点击New Query,输入dbccshrinkfile(N'www.product.com_log',30),点击Execute执行;

How to Shrink SharePoint Content Database Log File?

  1. 选择Content Database右键Properties,在Options中修改Recovery model为最初Full状态,点击OK保存;

How to Shrink SharePoint Content Database Log File?

  1. 此时到Content Database的Location查看,Log文件大小已经调整,shrink成功。

How to Shrink SharePoint Content Database Log File?

 

以上就是ShrinkSharePoint Content Database Log File的方法,希望能帮助到大家!

相关阅读 SharePoint中Office文件无法打开的解决方案如何快速生成SharePoint测试大文件如何查询SharePoint Library中空文件夹?如何快速备份SharePoint Farm Solution如何解决Event Viewer中SharePoint Error - Event ID 8321SharePoint 2016 CU安装失败,"Exception: The upgraded database schema doesn't match the TargetSchema"的解决方案InfoPath Error “此文档库已经被重命名或删除,或者网络问题导致文件无法保存…” 的解决方案SharePoint 2013 App概述How to Shrink SharePoint Content Database Log File?Project Web App Feature无法开启的解决方案

文章评论
发表评论

热门文章 SharePoint 2016 图文安装教程 后面有激活序列号、密钥分享[SharePoint入门教程]一SharePoint发展、工具及术语如何用 SharePoint Online创建团队网站?SharePoint Iframe 报错“此内容不能显示在一个框架中”

最新文章 SharePoint中Office文件无法打开的解决方案如何快速生成SharePoint测试大文件 如何查询SharePoint Library中空文件夹?如何快速备份SharePoint Farm Solution如何解决Event Viewer中SharePoint Error - Event ID 8321SharePoint 2016 CU安装失败,"Exception: The upgraded database s

人气排行 SharePoint 2016 图文安装教程 后面有激活序列号、密钥分享[SharePoint入门教程]一SharePoint发展、工具及术语如何用 SharePoint Online创建团队网站?SharePoint Iframe 报错“此内容不能显示在一个框架中”SharePoint 2013 安装图解 SharePoint安装步骤图解教程SharePoint 如何开启访问请求[SharePoint入门教程]一SharePoint概述[SharePoint入门教程]一创建SharePoint母版页

盖楼回复X

(您的评论需要经过审核才能显示)