We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, but this one has me stuck.

Trying to populate Full-Text indexes is not working. I create a basic table with some simple text in a new database and get the same results as old indexes.

The rebuild/repopulate procedure finishes, but I get zero rows in the index. The .dll in the message is present and the service accounts have access to this. My FTData also has data in it, so it seems there wouldn't be permission issue on this folder.

Application throws this error:

“PHP Warning: mssql_query() [function.mssql-query]:
message: Full-text catalog 'ikm_PageIndex_FText' is in an
unusable state. Drop and re-create
this full-text catalog. (severity 16)
in
E:\Inetpub\knowledgebase_insidemesa\lib\database\mssql.php
on line 154”

A microsoft discussion is the only post I found which had claimed to fix this - said it was registry related, but then didn't post the fix.

And that is exactly why SQL Server 2008 got reworked and now stores the full text index in the database files. I suggest kindly you open a ticket with MS PSS (Professional Support Services) and have them help you sort that out. Then update to a better version of SQL Server, 2012 preferred.
–
TomTomJan 3 '13 at 8:42

1 Answer
1

DirectoryNotFoundException uses the
HRESULT COR_E_DIRECTORYNOTFOUND which
has the value 0x80070003. Note that
DirectoryNotFoundException is also
thrown when COM interop programs see
the HRESULT STG_E_PATHNOTFOUND, which
has the value 0x80030003.

0x80070003 means that the directory cannot be found. It may be that the original location of the FTC has changed when it was attached to another database server. Either fix the path up or drop and re-create the full-text catalog and full-text indexes. SSMS should allow you to script out the indexes with ease.