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.
| 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! |
|
|
|
|
|
Full Text Search Catalog missing indexes