如何减小sharepoint日志的大小 [英] How to reduce the size of sharepoint logs

问题描述

您好！我们在内部部署了Sharepoint 2016.

Hello! We have Sharepoint 2016 on-premise.

Sharepoint_config中的日志大小约为291Gb。 

The size of logs in Sharepoint_config is about 291Gb. 

我们已完成2次完整备份但仍然知道可用空间来减少日志文件的数量（见图）。我需要做什么来缩小文件，因为它应该是日志。我不想将恢复模式设置为简单。现在它在完全恢复模式下是
。我是否必须第三次进行完整备份？

We have done 2 Full backups and still there is know available free space to reduce the amount of log file (see the picture). What o I have to do to shrink the file with logs as it is supposed to be. I don't want to set the recovery mode to simple. Now it's in the full recovery mode. Do I have to make the full backup for the third time?

推荐答案

您好

如果要减少db日志文件，则需要缩小db文件。

If you want to reduce the db log file, you need to shrink the db file.

右键单击SQL Server Management Studio中的数据库，任务，收缩，文件。

Right click your db in SQL Server Management Studio, Tasks, Shrink, File.

这篇关于如何减小sharepoint日志的大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！