Fulltext failure on a 2 node cluster

We have a 2 node windows 2003 enterprise edition cluster (S01 and S02).
-2 sql servers running in 2 different virtual servers (V01 and V02).
-The V01 SQL Server's preferred node is S01 and the V02 SQL Server's
preferred node is S02.
-On V01 one database has fulltext catalogs.

-When the V01 virtual server fails to S02, FULLTEXT will not work.
-MSSEARCH is running.
-Cluadmin shows FullText resource running
-I have NO error messages.
-Take note of the [Location of errorlog files] field. In other clusters this
field is blank.
-When I look at the registry key on S01
HKEY_LOCAL_MACHINE\Software\Microsoft\Search\1.0\SQLServer\SQLServer\STREAMLOGSDIRECTORY
I see the path [E:\mssql\ftdata\SQLServer\GatherLogs], but it does not
exist in S02 registry.

This is the only reference for that path I can find.

Observations...........
--------------Normal running mode---------------------------------
On V01 running on S01 (V02 is on S02)
Support Services - > R-Click - Full-Text Search -> Properties
Default location of catalog files = E:\MSSQL\FTDATA
Location of Temporary Files = C:\windows\temp\gthsrvc
Location of errorlog files =
E:\mssql\ftdata\SQLServer\GatherLogs

On V02 running on S02 (V01 is on S01)
Support Services - > R-Click - Full-Text Search -> Properties
Default location of catalog files = F:\MSSQL$V02\FTDATA
Location of Temporary Files = C:\windows\temp\gthsrvc
Location of errorlog files = ---Field is BLANK---
****************************************************
--------------Failover running
mode---------------------------------
On V01 running on S02 (V02 is on S02)
Support Services - > R-Click - Full-Text Search -> Properties
Default location of catalog files = E:\MSSQL\FTDATA
Location of Temporary Files = C:\windows\temp\gthsrvc
Location of errorlog files =
E:\mssql\ftdata\SQLServer\GatherLogs

On V02 running on S02 (V01 is on S02)
Support Services - > R-Click - Full-Text Search -> Properties
Default location of catalog files = F:\MSSQL$V02\FTDATA
Location of Temporary Files = C:\windows\temp\gthsrvc
Location of errorlog files =
E:\mssql\ftdata\SQLServer\GatherLogs
----------------------------------------------


.

Relevant Pages

  • Fulltext and cluster - odd problem
    ... -When the V01 virtual server fails to S02, FULLTEXT will not work. ... Default location of catalog files = F:\MSSQL$V02\FTDATA ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Full text index, catalog create Msg 1833, Level 16, State 3, Line
    ... My first question is: Why drop the catalog? ... DROP FULLTEXT CATALOG; ... CREATE FULLTEXT CATALOG FTC ... ALTER DATABASE <databaseName> SET RECOVERY SIMPLE. ...
    (microsoft.public.sqlserver.ce)
  • FT searching and weights
    ... I have a couple questions about fulltext searching.... ... My lower rankings should be higher than the highest ranking results. ... Catalog is populated. ... Or would it basically be the same thing as a full re-population? ...
    (microsoft.public.sqlserver.fulltext)
Loading