缩小TFS数据库的日志文件 [英] Shrinking log file for TFS databases
问题描述
我们有一个TFS2017环境.现在，大小每周都在增长，很长一段时间.
We have a TFS2017 environment. The size is growing every week for a long time now.
在这种环境下，我有多个馆藏；事务日志文件的大小非常大(超过155 Gb)
In this environment , i have multiple collection ; the size of Transaction Log File , is very big (overtop the 155 Gb)
我的问题是:对定义的TFS集合进行日志文件的安全存储是安全的吗?(在管理控制台中没有丢失数据或出现错误)?
My question is : It's safe to do a shirnk of the log file for the defined TFS collection ? (without loss data or getting error in administration console) ?
谢谢
推荐答案
是.可以.
日志文件在其中，因此您可以还原到两次完整备份之间的时间点.如果您在服务器上启用了备份并定期进行完整备份，则可以在每次完整备份之后截断日志.
The log file is there so you can restore to a point in time between full backups. If you have backups enabled on your server and regularly take a full backup, then you can truncate the logs after each full backup.
如果您只想删除日志"，则可以通过在拥有的每个应用程序层服务器上运行它来暂时关闭TFS: TFSServiceControl quiesce ，然后截断日志，然后使用重新打开TFS TFSServiceControl静默.
If you want to just "delete the logs" then temporarily turn off TFS by running this on every application tier server you have: TFSServiceControl quiesce, then truncate the logs, then turn TFS back on using TFSServiceControl unquiesce.
您可能还想验证您的备份策略.如果一切顺利，您将不会看到越来越大的日志文件.
You may also want to verify your backup strategy. If all is well, you shouldn't see a ever growing log file.
请参阅:
这篇关于缩小TFS数据库的日志文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
