Full-text catalog ‘%ls’ has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog.

Details
Product: SQL Server
Event ID: 7605
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: Full-text catalog ‘%ls’ has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog.
   
Explanation
Either:

  • The full-text path and file name no longer exists as specified in the registry for this catalog.
  • The full-text catalog is corrupted or for other reasons the catalog cannot be mounted by the MSSearch service.
   
User Action
Try these actions in order. If any step succeeds, skip the remaining steps.

  1. Execute sp_fulltext_catalog with @action = ‘rebuild’ for the catalog listed in the message. If this does not resolve your error, try the remaining steps and, if necessary, retry this step.
  2. Drop any full-text indexes associated with the specified catalog. Then drop the full-text catalog using sp_fulltext_catalog with @action = ‘drop’ for the catalog listed in the message. Then add back first the catalog and indexes, in that order. If this does not resolve your error, try the remaining steps, and then, if necessary, retry this step.
  3. Execute sp_fulltext_service with the clean_up parameter. If this does not resolve your error, try the remaining steps and, if necessary, retry this step.
  4. Verify that the following registry keys do not have a subkey with the same name as the full-text catalog specified in the message.

    For a default instance:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gather\SQLServer
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gathering Manager\Applications\SQLServer\Projects
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Indexer\SQLServer

    For a named instance:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gather\SQLServer$InstanceName
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Gathering Manager\Applications\SQLServer$InstanceName\Projects
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Search\1.0\Indexer\SQLServer$InstanceName

    WARNING: If you use Registry Editor incorrectly, you may cause serious problems requiring you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

    Do not follow these next steps unless you are completely removing the specified catalog:

    • Backup your registry.
    • If the path specified in the keys exists, then delete the last folder from the hard drive. For example, if the keys under the SQL0000500005 keys point to C:\Program Files\Microsoft SQL Server\MSSQL$Instance1\FTDATA\SQL0000500005, then delete just the SQL0000500005 subdirectory.
    • Delete all of the registry keys that have the same name as the full-text catalog.

    Related:

    Leave a Reply