We use SQL Server full text search functionality. As a result we have lots of full text log files like SQLFT0003200286.LOG.5 in the sql server error log folder. Is there anything we can do to ensure these files are periodically purged (oldest files purged first)?


It seems your option is this undocumented stored procedure running in a job:

EXEC sp_fulltext_recycle_crawl_log @ftcat = 'FullTextCatalogName';

Check the Recycle Fulltext Catalog Log Files article by Jonathan Kehayias.

I just tested it in a lab environment and it purges the oldest fulltext log file creating a new live file (in my lab I could see 1 live file and 6 old files, so this must be the default number of files SQL Server keeps).

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.