Sql-server – How to deal with SQL Server Full Text Log Files

full-text-searchsql serversql server 2014

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)?

Best Answer

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).

Related Solutions

Sql-server – SQL Server 2005: Full-text search, order by matches

You could try FREETEXTTABLE:

SELECT ft.[Rank], p.*
FROM dbo.products AS p 
INNER JOIN FREETEXTTABLE(products, productname, 'tennis ball') AS ft  
ON ft.key_column = p.key_column  
ORDER BY ft.[Rank] DESC;

Sql-server – SQL Server Full-Text Indexer with stoplists/stopwords

If your System Locale setting is different from English, then there is a known bug ( Microsoft Connect Item 753596 ) where the system locale stopwords are used instead of the fulltext index stopwords for documents stored in filetables.

Best Answer

Related Solutions

Sql-server – SQL Server 2005: Full-text search, order by matches

Sql-server – SQL Server Full-Text Indexer with stoplists/stopwords

Related Question