Problem building index for Full text search

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JB - 07 Nov 2005 15:46 GMT

I have a clustered SQL Server 2000 and have created a search catalog
for one of our databases using MS Search. I am getting some weird
behaviour: When the cluster group is running on Server1 the index gets
created successfully. However if I move the cluster group over to
Server2 the index fails to get created. Invoking "Start Full
Population.." on Server2 to build the index has the effect of clearing
the contents of the index. Has anyone seen this kind of behaviour
before? Are there any special cases to consider when using full text
search in a SQL cluster.

Cheers,
John

Reply to this Message

Hilary Cotter - 07 Nov 2005 17:00 GMT

I haven't seen this particular problem with clusters before. Are there any
error messages in the event log from MSSearch or MSSCI?

Signature

Hilary Cotter
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

> I have a clustered SQL Server 2000 and have created a search catalog
> for one of our databases using MS Search. I am getting some weird
[quoted text clipped - 8 lines]
> Cheers,
> John

Reply to this Message

JB - 28 Nov 2005 10:51 GMT

Hilary sorry for not replying to you sooner. I have tracked down the
problem I was having with full text search. The problem was caused by
installation of SQL 200 SP3 on SQL 2000 Failover Cluster. SP3 causes
query.dll and Tquery.dll to be unregistered. Solution and further
details to this problem in the following Microsoft KB article:

PRB: Microsoft Search Full-Text Catalog Population Fails When You
Upgrade SQL Server 2000 Failover Cluster to SQL Server 2000 Service
Pack 3
http://support.microsoft.com/default.aspx?scid=kb;en-us;817301

Regards,
John

Reply to this Message