MSSQLSERVER_2530
Applies to:
SQL Server
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
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.
See Also
Enable Indexes and Constraints
ALTER INDEX (Transact-SQL)
CREATE INDEX (Transact-SQL)
DBCC DBREINDEX (Transact-SQL)
Váš názor
https://aka.ms/ContentUserFeedback.
Připravujeme: V průběhu roku 2024 budeme postupně vyřazovat problémy z GitHub coby mechanismus zpětné vazby pro obsah a nahrazovat ho novým systémem zpětné vazby. Další informace naleznete v tématu:Odeslat a zobrazit názory pro