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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-08 : 10:14:39
|
| Rich writes "Hi,I have 3 databases, each with one fulltext catalog in, two of which do a full population once a day and the other has Change Tracking and Backgroud Update. I am running an active-passive sql cluster on 2 sql nodes.On a fairly frequent basis (varying between every 5days, and 2weeks), the population of each Catalog breaks, and although Enterprise Manager and FULLTEXTCATALOGPROPERTY tells me each catalog is in the process of updating/populating, no updates are being made. Furthermore, if i attempt to stop the population, either through EM or sp_fulltext_catalog, it still shows that the population/update is in progress. I have attempted to rebuild each catalog, but when i try and populate each again from scratch, it wipes the catalog of all items but will not restart populating, again despite it showing to the contrary.The only method i have found of rectifying this is to stop and restart the MS Search Service, and then rebuilding and repopulating each catalog.Unfortunately, there appears to be very little useful documentation anywhere on FullText Indexing. Can anyone help?" |
|
|
|
|
|
|
|
Full Text Catalogs Not Populating