Determining the Name of a Plain-Text Crawl Log File
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 crawl logs for a given instance, in this case, the first instance, are located in %ProgramFiles%\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder. The crawl log file follows the following naming scheme:
SQLFT<DatabaseID><FullTextCatalogID>.LOG[<n>]
- <DatabaseID>
The ID of a database. <dbid> is a five digit number with leading zeros.
- <FullTextCatalogID>
Full-text catalog ID. <catid> is a five digit number with leading zeros.
- <n>
Is an integer that indicates one or more crawl logs of the same full-text catalog exist.
For example, SQLFT0000500008.2 is the crawl log file for a database with database ID = 5, and full-text catalog ID = 8. The 2 at the end of the file name indicates that there are two crawl log files for this database/catalog pair.
See Also
Other Resources
Troubleshooting Full-Text Search
Full-Text Search Concepts