Hi guys,
I have a database with replicas on about 8 different servers. I’ve created a full text index for each replica and included the attachment option. Thing is, on a few of the replicas, doing the same search returns different results.
I’ve checked the database properties of these replicas and the doc count and size is the same. However, their indexes are completely different sizes - one of them has an index 90MB smaller that another.
I’ve deleted the indexes and recreated and there doesn’t appear to be any errors on the server such as the index pool being full or anything.
Can anyone help me?
Thanks.
Louise.
Subject: Index driving me insane
Have you deleted the .Ft folder or only via the index option of the db?
JYR
Subject: RE: Index driving me insane
Ah, only via the DB option. I heard that deleting the folders can screw up a database. Is that an old wives tale?
Louise.
Subject: RE: Index driving me insane
That is an old wives tale. If you want to clean up and remove the index you should also delete all *.ft files. Then re-create the Full Text index. Once the indexes have been initiated you might want to load an updall -f to force the re-build of the Full Text index.
Subject: RE: Index driving me insane
Well, not really the answer I was looking for but in the end, I deleted the indexes, made sure the FT folders were gone from the servers, waited an hour and then recreated and mysteriously, everything was fine.
Thanks for your help guys.
Louise.
Subject: RE: Index driving me insane
That is an old wives tale. If you want ot clean up and remove the index you should also delete all *.ft files. Then re-create the Ful Text index. Once the indexes have been initiated you might want ot load an updall -f to force the re-build of the Full Text index.