How to Recycle SQL Server Full text search error-log

Recycling command closes the current error log file and cycles the error log extension numbers just like a server restart. The new error log contains version and copyright information and a line indicating that the new log has been created.

Recycle "SQLFT.LOG" i.e. (Sql server full text search)

• Naming convention for FT log is as  SQLFT.LOG[]
• When an error occurs during a crawl, the Full-Text Search crawl logging facility creates and maintains a crawl log, which is a plain text file. Each crawl log corresponds to a particular full-text catalog
• By default these are located in %ProgramFiles%\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG folder
• The 2 at the end of the file name indicates that there are two crawl log files for this database/catalog pair

Syntax: no syntax

• Before SQL 2008 – restart the indexer
• SQL 2008 onwards– we cant re-cycle to full text log without restarting SQL server

Blog post is own by algaeservices.co.in