|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?