Full Text Indexes Disappeared When Added Node to Cluster

Giganews Newsgroups
Subject: Full Text Indexes Disappeared When Added Node to Cluster
Posted by:  Pat Hall (PatHa…@discussions.microsoft.com)
Date: Tue, 5 Jun 2007

Windows 2003 SP1  SQL 2000 SP3a  active/passive cluster    24x7 cluster
used by customer facing apps.

Added a new node to the cluster and failed over.  Now my Full Text Indexes
on my database are gone.

When I run  SELECT * FROM dbo.sysfulltextcatalogs    I get:

ftcatid    name    status    path    
5    em3_FTI    0    E:\em3_ion\FTDATA
            

When I check the location I can see the old files.  I have the script to
recreate the Full Text Indexes, if I could enable them on the database.

When I try to enable Full Text on the database I get:
Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text component cannot be loaded.

Have looked at BOL, MS Communities and SSWUG and haven’t found anything that
points to what I need do.  Everything says that Full Text is installed when I
install SQL Server (I used that same CD I did when I installed it the 1st
time – an RTM version).

What am I missing and how do I get it back?

Replies