关于 sql server 2012 全文索引 产生的log文件.

Question

请问 sql server 2012 全文索引产生的log文件.如:SQLFT0002400006.LOG这样的文件.

怎么删除呢?

尝试打开LOG文件夹删除会提示文件在用..

只能停止sql服务再删除吗?

Answer 1

是的                            

---

Love SQL

Answer 2

!

谢谢.

Answer 3

Don't delete current log file, you can delete old ones like log.1 and similar.

Answer 4

有什么方法或命令让SQLFTxxxxxxxx.LOG.变成SQLFTxxxxxxxx.LOG.1吗?像sql错误日志一样:sp_cycle_errorlog

Answer 5

Why you want to do that?

Answer 6

日志增加很快.C盘空间有限.只能暂时删除日志处理.如果可以的话.

Answer 7

Log file size depends on how often update full text indexed columns, you may move log file to bigger disk by modifying related registry key.