new records aren't being added to ft catalog (sql 2005 ee)

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
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@.nospam.com" <sql411nospamcom@.discussions.microsoft.com> wrote in
message news:D77BD52A-7107-4284-8522-60E95C45E15E@.microsoft.com...
> 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
|||Thanks, Hilary. I checked the logs initially and only saw a pause (from
backup) and resume (backup finished). it was weird because it happened
across all full-text catalogs - i could still do a contains search but they
just were idle as far as adding new records.
I did a reboot and that cleared it up. (I was hoping to avoid the reboot as
we are always doing business and it is difficult to get a maintenance period).
Thanks again,
robert