Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Full Text Search Catalog missing indexes

Author  Topic 

privateuly
Starting Member

1 Post

Posted - 2014-06-28 : 12:02:59
Hi,

We have a Full Text Search Catalog based on 2 tables. It runs well for months, but it suddenly just lost all the indexes. I can see that the catalog still exists but there are no indexes. Full text searches yield 0 records. I had to rebuilt the catalog and everything was fine again. It's happened at least twice before.

Any thought on what might have happened? When I went to sys.fulltext_indexes, I can see that the server started a crawl but it never finished. Does it delete all indexes when it starts a crawl? And what might cause a crawl to fail?

Thank you!
   

- Advertisement -