SQL Server 2000 Clustering

  • We have a SQL Server 2000 cluster running SP3A and ms031. We apply OS level patches the 3rd Saturday of the month. After the patches applied this last weekend, the Full Text Search startup get the following: "An error occurred during the online operation for instance <SQL Server Fulltext (IMDPRSQLV1)> 80070002 - The system cannot find the file specified."  After checking the cluster nodes, it appeared the folder FTDATA was missing on the node that is failing. Has anyone seen anything like this or know what to do to fix this? 

    Thanks in advance.  Mark

  • Well, I have found a KB artilcle (KB304282) that explains what to do. I was wondering if anyone else has had this issue? It would appear, based on this article, in our case we will need to rebuild the Full Text Search for one node.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply