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.

Thanks for your help!

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


"Larry" <anonymous (AT) discussions (DOT) microsoft.com> wrote