catalog not populating after recoverey - 08-26-2004 , 11:11 AM
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!
Re: catalog not populating after recoverey - 08-26-2004 , 11:32 AM
is there a timestamp column on this table? If so you could consider a
incremental population which will be somewhat shorter than a full
Are you able to identify all the missing records? If so you might want to
update them, ie
set FullTextCol1=FullTextCol1, FullTextCol2=FullTextCol2, etc
where pk in (list of missing rows)
Looking for a book on SQL Server replication?
"Larry" <anonymous (AT) discussions (DOT) microsoft.com> wrote