2 Servers - 2 sets of results : issues after DB move

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matthew Lee - 23 Jun 2004 23:13 GMT

I had a fulltext index set up nicely on server 1. Searches returning
correct results. Did a backup / restore to server 2. Dropped /
Rebuilt the fulltext indexes.

Now, the EXACT same phrases fail with the "ignored words" error. I
can run the same exact sproc on server1, get perfect results. Run it
on server 2, fails every time.

the phrase is quite specific:
CONTAINTS(*,"Mover NEAR has NEAR halted NEAR due NEAR to NEAR an NEAR
abort NEAR request")

Help, please.

Reply to this Message

Hilary Cotter - 24 Jun 2004 02:09 GMT

you have to edit your noise word list. Go to a command prompt and type net
stop mssearch. Then go to c:\Program Files\Microsoft SQL
Server\mssql\ftdata\sqlserver\config. Then edit the noise.enu file and
remove has, an, to from it. I take it you are living in America. If you are
living in the UK edit noise.eng

Then start up your mssearch again (at a command prompt issue a net start
mssearch), and do a full population.

Signature

Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

> I had a fulltext index set up nicely on server 1. Searches returning
> correct results. Did a backup / restore to server 2. Dropped /
[quoted text clipped - 9 lines]
>
> Help, please.

Reply to this Message

Hilary Cotter - 24 Jun 2004 02:11 GMT

try this

http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&c2coff=1&safe=off&selm
=eapJTswnBHA.2384%40tkmsftngp02

Signature

Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html

> I had a fulltext index set up nicely on server 1. Searches returning
> correct results. Did a backup / restore to server 2. Dropped /
[quoted text clipped - 9 lines]
>
> Help, please.

Reply to this Message