It’s not often that I have the need or opportunity to work with FullText Indexes, and it’s also not often that I come across a new thing to add to regularly schedule maintenance tasks in SQL Server. Today I happened to do at the same time. FullText Indexes in SQL Server are really not something that cause many people problems, until they do. When a problem does happen with a FullText population or crawl, the Log file for the catalog is the starting point for troubleshooting what is causing the problems. The crawl logs are in the instance ERRORLOG path
