|Try these actions in order. If any step succeeds, skip the remaining steps.
- 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.
- 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.
- 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.
- 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:
For a named instance:
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.