MSSQLSERVER_2530

Applies to: yesSQL Server (all supported versions)

Details

Attribute Value
Product Name SQL Server
Event ID 2530
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name DBCC_INDEX_IS_OFFLINE
Message Text The index "%.*ls" on table "%.*ls" is disabled.

Explanation

The DBCC statement cannot proceed because the specified index is disabled. After an index is disabled, it remains in a disabled state until it is rebuilt or dropped and re-created.

User Action

  1. Enable the disabled index by using one of the following methods:

    • ALTER INDEX statement with the REBUILD clause

    • CREATE INDEX with the DROP_EXISTING clause

    • DBCC DBREINDEX

  2. Rerun the DBCC statement.

See Also

Enable Indexes and Constraints
ALTER INDEX (Transact-SQL)
CREATE INDEX (Transact-SQL)
DBCC DBREINDEX (Transact-SQL)