This topic has not yet been rated - Rate this topic

MSSQLSERVER_9957

SQL Server 2005

New: 17 July 2006

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.

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.

Run the ALTER FULLTEXT CATALOG Transact-SQL statement, specifying REBUILD.

Alternatively, restore the full-text catalog from a backup.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions