| title | MSSQLSERVER_2530 |
|---|---|
| description | MSSQLSERVER_2530 |
| author | MashaMSFT |
| ms.author | mathoma |
| ms.date | 04/04/2017 |
| ms.service | sql |
| ms.subservice | supportability |
| ms.topic | reference |
[!INCLUDE SQL Server]
| 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. |
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.
-
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
-
-
Rerun the DBCC statement.
Enable Indexes and Constraints
ALTER INDEX (Transact-SQL)
CREATE INDEX (Transact-SQL)
DBCC DBREINDEX (Transact-SQL)