| Author |
Problem building index for Full text search
|
|
|
| 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
| |
| Hilary Cotter 2005-11-08, 4:10 pm |
| I haven't seen this particular problem with clusters before. Are there any
error messages in the event log from MSSearch or MSSCI?
--
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
"JB" <johnbrennan@gmail.com> wrote in message
news:1131378404.094114.271840@f14g2000cwb.googlegroups.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
> 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
>
| |
|
| 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/defaul...kb;en-us;817301
Regards,
John
|
|
|
|