如何清空或从WSS_logging数据库中删除数据 [英] How to empty or remove the data from WSS_logging database
问题描述
大家好,
我们不希望存储任何日志或使用历史数据等,以便在WSS_Logging数据库中进一步存储。因为它占用了我们巨大的空间已经驱动大约200GB左右。
我尝试了以下所有选项建议的\Found,但没有什么帮助减少或清空WSS_Logging数据库的数据。还有其他方法可以减少或者如果可能或建议清空此数据库。
尝试:
-Set-SPUsageDefinition -Identity $ def.Name -DaysRetained 1
-Disabled所有"SPUsageDefinition"&
-Ran计时器作业"数据导入"和"使用数据处理"
$
-使用"Wss_logging数据库"的收缩数据和日志文件。
$
-禁用来自中央管理员的所有日志记录。
然而,没有多少帮助或没有运气,以收回空间。
谢谢&此致,Krishna
您好
请尝试在SQL Server Management Studio中缩小数据库。
右键单击数据库 - >任务 - >收缩 - >数据库。
这里有一篇关于WSS_Logging的好文章。
https://www.petri.com/manage-wss_logging-database-sharepoint-2013
Hi All,
We dont want to store any of the logs or Usage history data etc to be stored any further in WSS_Logging database.As it took huge space of our drive like around 200GB already.
I tried all the below options suggested\Found,but nothing helped much to reduce or empty the data of WSS_Logging database.Is there any other ways to reduce or empty this database if possible or recommend.
Tried:
-Set-SPUsageDefinition –Identity $def.Name –DaysRetained 1-Disabled all the "SPUsageDefinition"
-Ran the timer jobs "Data import" and "Usage Data processing"
-Used Shrink Data and Log files of "Wss_logging Database".
-Disabled all the logging from Central admin.
However, no much help or no luck yet, to recover the space.
Thanks & Regards, Krishna
Hi
Please try to shrink your db in SQL Server Management studio.
Right click your db -> Tasks -> Shrink -> Databases.
And here is a good article for WSS_Logging.
https://www.petri.com/manage-wss_logging-database-sharepoint-2013
这篇关于如何清空或从WSS_logging数据库中删除数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!