MSSQLSERVER_9957
New: 17 July 2006
Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1399 |
Event ID |
9957 |
Event Source |
MSSQLSERVER |
Component |
SQLEngine |
Symbolic Name |
FTXT2_CATALOGCORRUPTED |
Message Text |
Full-text operation failed due to full-text catalog %ls is corrupted. Use rebuild rebuild catalog to correct the problem. |
Explanation
This message occurs when a full-text catalog is corrupted. Full-text catalogs can become corrupted for any of the following reasons:
- A failure occurs while the full-text catalog is being populated. This may cause inconsistencies in the data that is written to the catalog. Data inconsistencies are especially likely when a failover cluster node fails over to another node during population.
- The hard disk that stores the full-text catalog fails.
- A catalog file that belongs to the catalog directory is mistakenly deleted.
- The catalog is mistakenly attached to more than one database.
User Action
Run the ALTER FULLTEXT CATALOG Transact-SQL statement, specifying REBUILD.
Alternatively, restore the full-text catalog from a backup.
See Also
Other Resources
ALTER FULLTEXT CATALOG (Transact-SQL)
Backing Up and Restoring Full-Text Catalogs