Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQLSERVER_2530

Product Name

SQL Server

Product Version

10.50

Product Build Number

 

Event ID

2530

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

DBCC_INDEX_IS_OFFLINE

Message Text

The index "%.*ls" on table "%.*ls" is disabled.

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.

  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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.