catalog not populating after recoverey

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@.discussions.microsoft.com> wrote in message
news:0b5401c48b87$50ec3640$a601280a@.phx.gbl...
> 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!