Re: new records aren't being added to ft catalog (sql 2005 ee)
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Fri, 28 Dec 2007 07:29:50 -0500
check the full text logs, they can be found in C:\Program Files\Microsoft
SQL Server\MSSQL.1\MSSQL\LOG and will look like SQLFT0005600015.log
--
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sql411@xxxxxxxxxx" <sql411nospamcom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:D77BD52A-7107-4284-8522-60E95C45E15E@xxxxxxxxxxxxxxxx
Hi all,
I have multiple full-text catalogs on about 8 tables (sql server 2005 ee -
all varchar(max)).
A few days ago, they all went to an idle status and won't start picking up
any new changes - all catalogs are auto update.
when i say 'idle' - mean :
objectpropertyex ( [table object_id] , 'TableFulltextPopulateStatus' ) = 0
objectpropertyex ( [catalog_id] , PopulateStatus) = 0
and
objectpropertyex ( table object_id , 'TableFulltextItemCount' ) shows that
there are many rows missing from the table so there is much work to be
done.
i have seen this once before and ended up doing a rebuild but I hope to
avoid that this time around as it takes several days to rebuild all
catalogs.
Has anyone seen anything similar to this or have any suggestions for the
full-text catalog to start 'picking back up' the auto changes?
Many thanks,
Robert Towne
.
- Prev by Date: Re: Different results from like and contains
- Next by Date: Re: Different results from like and contains
- Previous by thread: Different results from like and contains
- Index(es):
Relevant Pages
|
