sql server full text search: catalog not populating after recoverey -- sql server full text search

catalog not populating after recoverey

Larry
8/26/2004 9:11:16 AM

sql server full text search:

Hello -

sql server 2000 sp2

I have a catalog that has been recovering for 3 days. It
finally says "idle". However, it is missing about 20,000
records. The table being indexed has a little over 3
million rows and the catalog item count shows 2.8 million.

I ran a ft query and it is missing records that were
added several days ago. I am using change tracking /
background process. Is there something I can run or do
besides running a full population. (it could take a week
to repopoulate the data.

Re: catalog not populating after recoverey

Hilary Cotter
8/26/2004 12:32:56 PM

is there a timestamp column on this table? If so you could consider a
incremental population which will be somewhat shorter than a full
population.

Are you able to identify all the missing records? If so you might want to
update them, ie

update TableName
set FullTextCol1=FullTextCol1, FullTextCol2=FullTextCol2, etc
where pk in (list of missing rows)

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

[quoted text, click to view]