March 13, 2014 at 10:58 am
Full text search is not returning recently updated values.
Since the FTS index catalog was rebuilt it is not aware of changes.
Any ideas.
I'm thinkg rebuild and the restart or the other way around.
March 17, 2014 at 8:43 am
A restart didn't resolve the issue, isa rebuild be advisable in core working hours.
ANYBODY???
March 17, 2014 at 9:02 am
exec sp_fulltext_catalog @ftcat= 'FTNAME',@action = 'start_incremental'
Possibly down to this???
March 18, 2014 at 6:05 am
Looks like I'm answering my own questions.
ALTER FULLTEXT INDEX ON [TableName] SET CHANGE_TRACKING Auto
They were set to Manual.
SELECT object_name(object_id) table_name, *
FROM sys.fulltext_indexes
GO
March 18, 2014 at 7:34 am
It has been a while since I had a DB with a FTI, but from time to time I found it to report incorrect results despite the Auto-Index was on.
I resorted to rebuilding the FTI nightly. I was fortunate that the index was small enough where I could afford the time to rebuild it.
I found some rather quirky things with the FTI especially where the Auto-Index would for some reason switch off. I ultimately created a job that looked at all of the FTIs on all of the DBs to insure the Auto-Index was always on, and if it was off it would turn it back on along with rebuilding the index.
Kurt
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply